Remove message when opening workbook.

I have a workbook that users open, when it is opened it has a message saying "This workbook contains links to other sources" "UPDATE" "DONT UPDATE".
I would like this message to not appear and for it to automatically choose "dont update"
Is this possible?
Who is Participating?
reitzenConnect With a Mentor Commented:
No, it cannot choose this itself.

If you have access to the file, you might be able to prevent these prompts by blocking them in the Workbook_Open event.  However, if this file is generated from an outside source then this will not be an option.

If you do have access to this file, then again, you may have a prompt where the user will need to "Enable content" which will allow the macro code to run.  This prompt depends on the enable/disable option that is set in your Trust Center.
You may be able to, as long as you trust the source the links are feeding from.

You can find the option to turn this prompt off in the Trust Center.

2007:  Office button > Excel options > Trust Center > Trust Center Settings > External Content
2010:  File > Options > Trust Center > Trust Center Settings > External Content

You can select the "Disable" options for workbook links.  You may, or may not, need the data connections option.

RobJanineAuthor Commented:
That will not work as it has to run on my staff laptop's on site. Can it somehow chose "dont update" it self?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.