What version of Excel are you using? 2000 (9.0.6926 SP-3)

I am in automatic calculation mode.

Ctrl+Alt+F9 does not cause them to update after the file is opened or
refresh, but if I manually delete the contents of the cells in the source
worksheet the target worksheet updates correctly.

The formula in one of the cells containing the links is =RAW DATA!C31

The name of the source worksheet is called €œRAW DATA€�.

Please help,
Chris Petta


"Bill Manville" wrote:

Not a problem I have heard of before.

What version of Excel are you using?

When the links have not updated after a refresh of the table, what
calculation mode are you in (Tools / Options / Calculation)?
If you are in manual mode they would not normally update.
If you are in automatic mode they should update; does Ctrl+Alt+F9 cause
them to update correctly?.

What is the formula in one of the cells containing the links?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup