Updating Links in Excel 97

Tinsel

New Member
Joined
Nov 2, 2004
Messages
46
I have a spreadsheet (for example purposes, Sheet A) with many calculations so I have set it to manual recalculation. Sheet A has some links to another spreadsheet (Sheet B). Sheet B is updated, saved and closed whilst Sheet A is closed. Sheet A is then reopened and F9 pressed to update the calculations and the links. However, it will not update the linked cells unless Sheet B is opened up again.

This is Excel 97 - is it something to do with the version?

Is there any way around this ?
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
When SheetA is re-opened, do you get a prompt "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?" ?

If so, what do you click, Yes, or No?

If not, change the workbook options under menu command Tools/Options/Calculation and ticking the Update Remote References check-box.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top