Edit Mode Help

The Standard Add-in has an ‘Edit Mode’ that shows you where your queries and any cell references have been placed (for start and end dates, for example). When Edit Mode is ON, the add-in places Excel comments on all the referenced cells.

Editing the Worksheet (Edit Mode On)

If you are going to move things around on your worksheet, rename a worksheet, or insert rows or columns, turn the Edit Mode ON first. After any worksheet change, be sure to select a worksheet cell¬†after the change, and check the comments to make sure that the add-in has re-synchronized them to point to the new cell locations. The comment should contain the new cell location. Do NOT change the comments yourself — the add-in needs to do that to keep things aligned.

Turning Edit Mode Off

While Edit Mode is on, the add-in will intercept and process every click you make into the worksheet, looking for changes. This will slow things down in larger workbooks. Turn Edit Mode OFF when you are finished moving things around. It is not necessary to have Edit Mode on to Refresh a workbook, only if you want to move a query or cell reference to a different location or change worksheet names.