Suppress Update Links dialog AND don't update links

Paul Martin · 07-16-2006, 10:45 PM

Hi all

I have created an Excel utility that works on the other open workbooks.
When other workbooks are opened, I want to suppress the Update Links
dialog (using Application.AskToUpdateLinks = False) but I also DON'T
want the links to be updated. Users will be on Excel 97. Any
suggestions as to a VBA solution that I can put in the utility which
will be open first?

Thanks in advance

Paul Martin
Melbourne, Australia

Dave Peterson · 07-17-2006, 12:25 PM

Drop the .asktoupdatelinks.

And change your code in your utility to open the file without updating links.

You'll see an option on the workbooks.open statement that can be used to specify
how links should be treated. See VBA's help for all the options.

Paul Martin wrote:
>
> Hi all
>
> I have created an Excel utility that works on the other open workbooks.
> When other workbooks are opened, I want to suppress the Update Links
> dialog (using Application.AskToUpdateLinks = False) but I also DON'T
> want the links to be updated. Users will be on Excel 97. Any
> suggestions as to a VBA solution that I can put in the utility which
> will be open first?
>
> Thanks in advance
>
> Paul Martin
> Melbourne, Australia

--

Dave Peterson

Paul Martin · 08-01-2006, 10:10 PM

Hi Dave

The workbooks are being opened manually, and will not be opened
programmatically.

Paul

Dave Peterson wrote:

> Drop the .asktoupdatelinks.
>
> And change your code in your utility to open the file without updating links.
>
> You'll see an option on the workbooks.open statement that can be used to specify
> how links should be treated. See VBA's help for all the options.
>
> Paul Martin wrote:
> >
> > Hi all
> >
> > I have created an Excel utility that works on the other open workbooks.
> > When other workbooks are opened, I want to suppress the Update Links
> > dialog (using Application.AskToUpdateLinks = False) but I also DON'T
> > want the links to be updated. Users will be on Excel 97. Any
> > suggestions as to a VBA solution that I can put in the utility which
> > will be open first?
> >
> > Thanks in advance
> >
> > Paul Martin
> > Melbourne, Australia
>
> --
>
> Dave Peterson

Dave Peterson · 08-01-2006, 10:20 PM

If you're using xl2002+, you can use:
edit|links|startup prompt (along with that application setting) to stop the
update.

Paul Martin wrote:
>
> Hi Dave
>
> The workbooks are being opened manually, and will not be opened
> programmatically.
>
> Paul
>
> Dave Peterson wrote:
>
> > Drop the .asktoupdatelinks.
> >
> > And change your code in your utility to open the file without updating links.
> >
> > You'll see an option on the workbooks.open statement that can be used to specify
> > how links should be treated. See VBA's help for all the options.
> >
> > Paul Martin wrote:
> > >
> > > Hi all
> > >
> > > I have created an Excel utility that works on the other open workbooks.
> > > When other workbooks are opened, I want to suppress the Update Links
> > > dialog (using Application.AskToUpdateLinks = False) but I also DON'T
> > > want the links to be updated. Users will be on Excel 97. Any
> > > suggestions as to a VBA solution that I can put in the utility which
> > > will be open first?
> > >
> > > Thanks in advance
> > >
> > > Paul Martin
> > > Melbourne, Australia
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Paul Martin · 08-02-2006, 07:50 PM

Hi Dave

No, unfortunately users could be using any version from 97 to 2003, but
mostly 97.

Paul

Dave Peterson wrote:
> If you're using xl2002+, you can use:
> edit|links|startup prompt (along with that application setting) to stop the
> update.
>
> Paul Martin wrote:
> >
> > Hi Dave
> >
> > The workbooks are being opened manually, and will not be opened
> > programmatically.
> >
> > Paul
> >
> > Dave Peterson wrote:
> >
> > > Drop the .asktoupdatelinks.
> > >
> > > And change your code in your utility to open the file without updating links.
> > >
> > > You'll see an option on the workbooks.open statement that can be used to specify
> > > how links should be treated. See VBA's help for all the options.
> > >
> > > Paul Martin wrote:
> > > >
> > > > Hi all
> > > >
> > > > I have created an Excel utility that works on the other open workbooks.
> > > > When other workbooks are opened, I want to suppress the Update Links
> > > > dialog (using Application.AskToUpdateLinks = False) but I also DON'T
> > > > want the links to be updated. Users will be on Excel 97. Any
> > > > suggestions as to a VBA solution that I can put in the utility which
> > > > will be open first?
> > > >
> > > > Thanks in advance
> > > >
> > > > Paul Martin
> > > > Melbourne, Australia
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson

Dave Peterson · 08-02-2006, 08:20 PM

I'm out of ideas.

Paul Martin wrote:
>
> Hi Dave
>
> No, unfortunately users could be using any version from 97 to 2003, but
> mostly 97.
>
> Paul
>
> Dave Peterson wrote:
> > If you're using xl2002+, you can use:
> > edit|links|startup prompt (along with that application setting) to stop the
> > update.
> >
> > Paul Martin wrote:
> > >
> > > Hi Dave
> > >
> > > The workbooks are being opened manually, and will not be opened
> > > programmatically.
> > >
> > > Paul
> > >
> > > Dave Peterson wrote:
> > >
> > > > Drop the .asktoupdatelinks.
> > > >
> > > > And change your code in your utility to open the file without updating links.
> > > >
> > > > You'll see an option on the workbooks.open statement that can be used to specify
> > > > how links should be treated. See VBA's help for all the options.
> > > >
> > > > Paul Martin wrote:
> > > > >
> > > > > Hi all
> > > > >
> > > > > I have created an Excel utility that works on the other open workbooks.
> > > > > When other workbooks are opened, I want to suppress the Update Links
> > > > > dialog (using Application.AskToUpdateLinks = False) but I also DON'T
> > > > > want the links to be updated. Users will be on Excel 97. Any
> > > > > suggestions as to a VBA solution that I can put in the utility which
> > > > > will be open first?
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > > Paul Martin
> > > > > Melbourne, Australia
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson