#1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 4
Default UPDATE - HELP

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 35,218
Default UPDATE - HELP

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 4
Default UPDATE - HELP

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 35,218
Default UPDATE - HELP

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 4
Default UPDATE - HELP

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   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 4
Default UPDATE - HELP

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic update of spreadsheet & automatic update between workboo Losva Excel Worksheet Functions 6 September 12th 08 03:22 PM
i want to update one excel file the other one update automaticaly Basant New Users to Excel 1 December 16th 06 12:50 AM
update ceemo Excel Discussion (Misc queries) 2 July 13th 06 01:40 PM
keep value from last update and don't ask to update links jh3016 Excel Discussion (Misc queries) 3 July 25th 05 01:37 AM
Update / don't update dialog box Tim Kredlo Excel Worksheet Functions 1 November 11th 04 04:25 PM


All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"