Update links prompt not wanted

[neeraj]

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]

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

[neeraj]

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]

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

[neeraj]

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]

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