When using the "Link to Excel worksheet" method the links Plan Guru 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. In this example I've linked to the tab "Linked Sheet" which is the first worksheet of the Excel workbook 2.
When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.
When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically.
For a step-by-step guide on how to create a chart from your Excel data using think-cell, please consider the example from Introduction to charting.
In Power Point, when the mouse pointer is on a slide, the familiar insertion rectangle appears.To find where links are used in a workbook, search in formulas for “.xl*!”; that is, an Excel file name followed by an exclamation mark.There are many options in Excel that control this depending on the kind of link it is.I’ll cover the usual external links in formulas first, then finish up with the other kinds.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. To correct this you will either have to move your Excel Data back to the original location, or update your links. Or you can relink the cells by highlighting your range, clicking the "Add" button and checking of the appropriate time periods.Plan Guru will notify you that each period is already assigned, and will prompt you to accept or reject the changes.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. Restore the links to their original state by returning the "Liked Sheet" tab to its original position within the Excel workbook (3rd tab). You should now be able to refresh and update your links without issue. Using the same example above, I'll make a different kind of change to the Excel workbook. Here I've taken my linked data range in Excel and cut and pasted it several rows down. Next I try to Refresh my Excel Links, the amounts won't get updated.Step 1: Create the table in Excel The first step is to create the table of data in Excel so that it looks exactly the way you will want it to look on the slide, including titles, row labels, column labels, gridlines, text and background colors and text formatting.Step 2: Copy the table in Excel Using your mouse or arrow keys, highlight the table of data in Excel. The slide layout with a title only is usually a good choice if the imported table will be the main focus of the slide.