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!

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!