How to stop spreadsheets automatically updating on opening?

  • Thread starter Thread starter Victor Delta
  • Start date Start date
V

Victor Delta

I have just converted to Vista but am still using Excel 2002/XP.

Now, when I open a spreadsheet which contains external links, it
automatically updates. Previously a window used to pop-up asking me if I
wanted to update. I would like to return to this mode - how does one do it
please?

I have tried looking at all the option and link options but cannot find the
solution. I bet the answer is very simple!

TIA

V
 
Don Guillett said:
edit>links>startupprompt
Click to expand...

Yes, I have got the first option selected 'Lets users choose...' but the
spreadsheets still automatically update...

V
 
Back
Top