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 Dont 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 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 dont 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 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 Dont 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 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 Dont 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