Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 22nd 05, 10:19 PM
neeraj
 
Posts: n/a
Default Update links prompt not wanted

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks

  #2   Report Post  
Old September 23rd 05, 12:21 AM
Dave Peterson
 
Posts: n/a
Default

Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks


--

Dave Peterson
  #3   Report Post  
Old September 23rd 05, 02:47 PM
neeraj
 
Posts: n/a
Default

But if the developer chooses the option 'Dont alert and dont update', the end
result is that the user is neither alerted nor updated regardless of user's
settings on "ask to update" checkbox. In this case, Excel does not let the
user override the developer's settings?

"Dave Peterson" wrote:

Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks


--

Dave Peterson

  #4   Report Post  
Old September 23rd 05, 03:10 PM
Dave Peterson
 
Posts: n/a
Default

Yep. That's the way it worked for me, too.

There seem to be some flaws in my theory <bg.



neeraj wrote:

But if the developer chooses the option 'Dont alert and dont update', the end
result is that the user is neither alerted nor updated regardless of user's
settings on "ask to update" checkbox. In this case, Excel does not let the
user override the developer's settings?

"Dave Peterson" wrote:

Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Old September 23rd 05, 05:52 PM
neeraj
 
Posts: n/a
Default

Thanks for the confirmation. Please let me know if and when you have the
answer...

"Dave Peterson" wrote:

Yep. That's the way it worked for me, too.

There seem to be some flaws in my theory <bg.



neeraj wrote:

But if the developer chooses the option 'Dont alert and dont update', the end
result is that the user is neither alerted nor updated regardless of user's
settings on "ask to update" checkbox. In this case, Excel does not let the
user override the developer's settings?

"Dave Peterson" wrote:

Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks

--

Dave Peterson


--

Dave Peterson



  #6   Report Post  
Old September 23rd 05, 06:34 PM
Dave Peterson
 
Posts: n/a
Default

I think you found the answer--it's just that excel doesn't work the way you
want/expect it.



neeraj wrote:

Thanks for the confirmation. Please let me know if and when you have the
answer...

"Dave Peterson" wrote:

Yep. That's the way it worked for me, too.

There seem to be some flaws in my theory <bg.



neeraj wrote:

But if the developer chooses the option 'Dont alert and dont update', the end
result is that the user is neither alerted nor updated regardless of user's
settings on "ask to update" checkbox. In this case, Excel does not let the
user override the developer's settings?

"Dave Peterson" wrote:

Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks

--

Dave Peterson


--

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
keep value from last update and don't ask to update links jh3016 Excel Discussion (Misc queries) 3 July 25th 05 01:37 AM
Edit Links: make update manual Chrissorr Excel Discussion (Misc queries) 5 May 11th 05 11:57 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Manually update links Emma Excel Worksheet Functions 0 February 22nd 05 01:23 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM


All times are GMT +1. The time now is 01:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017