Links not linking
I download four spreadsheets from an outside source and then link the data
into a summary workbook. I expect to see the data from each of the outside ..xls files in a worksheet in the summary workbook, but it's always previous data. I end up cutting and doing a Paste Special with Paste as Link. I have checked all the links and they are automatic. The Tools/Options/Calculations/Update Remote References is checked. Before I send the summary out, I break the links and that happens, but I can't understand why they won't update. (I swear they used to not so long ago!) Help! |
Links not linking
Let me ask the obvious questions...
The ddownloaded files.. are the saved to the same names as your previous files? when you open the summary spreadsheet, are you selecting Update Values? If you get an error about not updating values, do you go to Edit - Links and update from there? In Tools - Options - Calculation, are Update remote references and Save external link values checked? In the Edit tab, is Ask to update automatic links checked? "Lambi000" wrote: I download four spreadsheets from an outside source and then link the data into a summary workbook. I expect to see the data from each of the outside .xls files in a worksheet in the summary workbook, but it's always previous data. I end up cutting and doing a Paste Special with Paste as Link. I have checked all the links and they are automatic. The Tools/Options/Calculations/Update Remote References is checked. Before I send the summary out, I break the links and that happens, but I can't understand why they won't update. (I swear they used to not so long ago!) Help! |
All times are GMT +1. The time now is 05:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com