Linked cells in excel not updating
Not sure if its just my computer yet, currently testing the issue with different computers.I have a think-cell chart linked to an Excel workbook and the Excel's calculation mode is set to manual.
I have linked few excel cells in a word document, using paste special (paste link) option and saved the document as macro enabled document with extension as i have few macros on other pages.The option to link an OLE is only available if you choose the Create from File option during object insertion.If you insert the object using the Create New option, the object will not be linked.The cell references were all correct, but for whatever reason they would not update.I tried a couple of things - "Formulas - Automatic" was checked, clicking "Calculate Now" and "Calculate Sheet" would not update the model.
Search for linked cells in excel not updating:
The surprising part is when saved the document in format, the links are working.