If you change data in Excel and then press
F9 to start manual recalculation, the chart is not changed.
This problems occurs only under the following circumstances:
The file was saved in an older Excel version than the one you use to open the file.
Excel's calculation mode is set to manual.
The linked data is at least partially calculated from other Excel data.
All Excel cells containing formulas are locked.
If the think-cell chart is not updated after copy/paste of data please refer to the knowledge base article
When opening a workbook for the first time in a newer Excel version, change data and trigger a recalculation
Once the workbook is saved with the newer Excel version, a single recalculation suffices.
Excel recalculation behaves differently when you first open a workbook saved in an earlier version of Excel than when you open a workbook created in the current version. This is described in Microsoft's Excel Help under the heading,
Learn about calculating workbooks that were created in an earlier version of Excel.
If your company has a Microsoft Office Support contract and you want to contact Microsoft to ask for a fix, you may refer to Microsoft case number REG:113070110555536.
The problem can be reproduced without think-cell.
An Excel range embedded in a word document, linked to the source workbook, shows the same behavior:
Open a new workbook in Excel 2007.
Set the calculation mode to manual by clicking on
Office button (top left corner of the Excel window) →
Excel Options →
and set Workbook Calculation to
Enter the following data and formulae:
Lock cell B3 by right-clicking on the cell →
Format Cells →
Save the workbook in Excel 2007.
Open the workbook in Excel 2010.
Select Sheet2!A1:B3 and copy it with Ctrl+C
Open Word 2010 with a new document.
- Paste the copied Excel cells via:
Paste Special →
Paste link: Unformatted Text
In Excel 2010, enter the value 2 in Sheet1!A1. Press Enter
Result: The data in Sheet2!B3 is updated, but the linked cell range in Word is not updated.