I have various workbooks that the master picks up to transfer data, but some
of the workbooks have links to other files, hence I keep getting a message to
either update or not. This means I have to keep pressing the Don’t Update for
the program to move on. I have used Application.DisplayAlerts = False
command, but to no avail. Is there something else I can use.
Many thanks again, John

If you go to Edit > Links, there's an option to turn off automatic
updating of links, or something like that.

--JP

On Nov 28, 8:03*am, JohnUK <Joh...@discussions.microsoft.com> wrote:
> I have various workbooks that the master picks up to transfer data, but some
> of the workbooks have links to other files, hence I keep getting a message to
> either update or not. This means I have to keep pressing the Don’t Update for
> the program to move on. I have used Application.DisplayAlerts = False
> command, but to no avail. Is there something else I can use.
> Many thanks again, John

Hi JP. Thanks for that, but that would mean me disabling each workbook and
saving changes, which I don’t want. What I need is something I can insert
into the code that will stop the alerts from appearing as each workbook
opens. Appreciate your feedback. John

"JP" wrote:

> If you go to Edit > Links, there's an option to turn off automatic
> updating of links, or something like that.
>
> --JP
>
> On Nov 28, 8:03 am, JohnUK <Joh...@discussions.microsoft.com> wrote:
> > I have various workbooks that the master picks up to transfer data, but some
> > of the workbooks have links to other files, hence I keep getting a message to
> > either update or not. This means I have to keep pressing the Don’t Update for
> > the program to move on. I have used Application.DisplayAlerts = False
> > command, but to no avail. Is there something else I can use.
> > Many thanks again, John
>
>

Hi again. I found a way of disabling the pop ups by using
Application.AskToUpdateLinks = False, but the drawback is that I lose
anything that is kept in memory that I need to copy and paste from one
workbook to another. (Ha - Two steps forward, one back) has anyone got an
answer to this problem?
John

"JP" wrote:

> If you go to Edit > Links, there's an option to turn off automatic
> updating of links, or something like that.
>
> --JP
>
> On Nov 28, 8:03 am, JohnUK <Joh...@discussions.microsoft.com> wrote:
> > I have various workbooks that the master picks up to transfer data, but some
> > of the workbooks have links to other files, hence I keep getting a message to
> > either update or not. This means I have to keep pressing the Don’t Update for
> > the program to move on. I have used Application.DisplayAlerts = False
> > command, but to no avail. Is there something else I can use.
> > Many thanks again, John
>
>