Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Updating Today() On opening | Excel Worksheet Functions | |||
How do I stop a date from automatically updating? | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) |