Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
I have recently bought a new machine with windows vista and I have installed
office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig |
#2
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl Craig McLaughlin wrote: I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
hi thanks for your reply - unfortunately I tried the solution - it didnt
work. Firstly I did not have the directory 9 as mentioned in the post solution, BUT i did have a 11 and 10 in the same location so I added the DWORD to both these directories under options but to no avail. Any other ideas? thanks craig "Dave Peterson" wrote in message ... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Craig McLaughlin wrote: I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
It's worked for me and several other posters.
I'd say double check your work and try it again. 11 is for xl2003. Craig McLaughlin wrote: hi thanks for your reply - unfortunately I tried the solution - it didnt work. Firstly I did not have the directory 9 as mentioned in the post solution, BUT i did have a 11 and 10 in the same location so I added the DWORD to both these directories under options but to no avail. Any other ideas? thanks craig "Dave Peterson" wrote in message ... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Craig McLaughlin wrote: I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig -- Dave Peterson -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
thanks. Yeah checked again still no avail. I am beginning to think that it
is a bug when 2003 is installed on Vista Ultimate. As I said it continually prompts for the update links despite the setting being set to automatic update without prompting. What makes matters worse is that I have loads of excel sheets with links and it is a pain having to click on update links everytime. Any other ideas? Cheers Craig "Dave Peterson" wrote in message ... It's worked for me and several other posters. I'd say double check your work and try it again. 11 is for xl2003. Craig McLaughlin wrote: hi thanks for your reply - unfortunately I tried the solution - it didnt work. Firstly I did not have the directory 9 as mentioned in the post solution, BUT i did have a 11 and 10 in the same location so I added the DWORD to both these directories under options but to no avail. Any other ideas? thanks craig "Dave Peterson" wrote in message ... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Craig McLaughlin wrote: I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig -- Dave Peterson -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
Boy do I feel stupid.
After searching every dialog box and webpage I found a checkbox in options which seems to override the links settings. Under Edit tab there is an option to ask to update links. In my defence I do think that it is a bit daft to have options in links to ask to update and prompt only to have it over ridden by another checkbox options elsewhere. thanks for your time Craig "Craig McLaughlin" wrote in message ... thanks. Yeah checked again still no avail. I am beginning to think that it is a bug when 2003 is installed on Vista Ultimate. As I said it continually prompts for the update links despite the setting being set to automatic update without prompting. What makes matters worse is that I have loads of excel sheets with links and it is a pain having to click on update links everytime. Any other ideas? Cheers Craig "Dave Peterson" wrote in message ... It's worked for me and several other posters. I'd say double check your work and try it again. 11 is for xl2003. Craig McLaughlin wrote: hi thanks for your reply - unfortunately I tried the solution - it didnt work. Firstly I did not have the directory 9 as mentioned in the post solution, BUT i did have a 11 and 10 in the same location so I added the DWORD to both these directories under options but to no avail. Any other ideas? thanks craig "Dave Peterson" wrote in message ... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Craig McLaughlin wrote: I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open them it keeps asking to update. I have change the settings for updates to update without prompt and then saved it but when I open the file again it asks to update the links. It is really annoying can anyone shed any light on this. thanks craig -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
i want to update one excel file the other one update automaticaly | New Users to Excel | |||
update | Excel Discussion (Misc queries) | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
Update / don't update dialog box | Excel Worksheet Functions |