How to stop spreadsheets automatically updating on opening?
 

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

How to stop spreadsheets automatically updating on opening?
 

editlinksstartupprompt

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Victor Delta" wrote in message
...
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

How to stop spreadsheets automatically updating on opening?
 

"Don Guillett" wrote in message
...
editlinksstartupprompt

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

V