View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lambi000 Lambi000 is offline
external usenet poster
 
Posts: 18
Default 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!