Updating links in excel

If Power Point is not yet running, it starts automatically.In Power Point, when the mouse pointer is on a slide, the familiar insertion rectangle appears.An external link formula shows the full path to the source if that workbook is closed, otherwise it shows only the workbook name in the path.

If you get a prompt to update links when you open a workbook, but you cannot find any cells containing links, the link is probably in a name. If the source workbooks are open at the same time as the target, the formulas are part of the recalculation chain as normal.

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.

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.

This is how the example chart data looks in Excel: To create a chart from Excel, select the desired data range in your Excel workbook, including series and category labels: The layout of your data must match the layout of think-cell’s internal datasheet: Column charts are usually created from data columns, whereas bar charts are created from data rows.


Leave a Reply