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!
|