When using the "Link to Excel worksheet" method the links PlanGuru makes to the Excel workbook can be disrupted if changes are made to the underlying Excel Workbook.
Two types of changes can disrupt the links to your Excel Workbook.
The tab order changes:
1. In this example I've linked to the tab "Linked Sheet" which is the first worksheet of the Excel workbook
2. After creating the links I decide to alter the Linked Excel workbook. In doing so I change the position of the "Liked Sheet" tab from 1st to 3rd.
3. Next, after making changes to the Excel workbook I go back into PlanGuru and try to "Refresh Excel Links" but my values don't get updated correctly.
4. To investigate, I click on the "Link Test Category" and click the change links button.
5. When the link to Excel interface is open, you'll notice that the focus is no longer on the correct tab. When I try to put the focus on the correct tab ("Linked Sheet") I get the following error message.
This is a direct result of the changes made to the Excel workbook documented in step 2 above.
6. Restore the links to their original state by returning the "Liked Sheet" tab to its original position within the Excel workbook (3rd tab).
7. You should now be able to refresh and update your links without issue.
Cut and Paste Cells to different location
1. Using the same example above, I'll make a different kind of change to the Excel workbook. Instead of moving tabs, I'll move data. Here I've taken my linked data range in Excel and cut and pasted it several rows down.
2. Next I try to Refresh my Excel Links, the amounts won't get updated. Also, I use the change links button to go and update my links, you'll notice that the numbers I've linked are no longer highlighted in red.
3. To correct this you will either have to move your Excel Data back to the original location, or update your links.
4. Or you can relink the cells by highlighting your range, clicking the "Add" button and checking of the appropriate time periods. PlanGuru will notify you that each period is already assigned, and will prompt you to accept or reject the changes.