Updating of linked worksheets

Hello Rob

Thank you for your question and welcome to the forum.

If you wish to update the links in a file manually, you can set this up by going through Edit-Links. This option will also stop the update prompt from appearing when the file is opened.

To suppress the message and leave the links (not updated) until you choose to update them, follow these steps:

1. Go to Edit-Links.
2. Click the Startup Prompt button.
3. Select the 'Don't display the alert and don't update automatic links' option.

This choice affects all users of the workbook. However, this choice applies only to that particular workbook.

When you want to update the links:
1. Go to Edit-Links.
2. Click Update Values.
3. Click Close.

I hope this helps.

Kind regards
Amanda