Disable links to other workbooks
 

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

Disable links to other workbooks
 

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

Disable links to other workbooks
 

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

Disable links to other workbooks
 

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