Forum Discussion
Excel Remove Message and auto fill the year
I have two questions I need to get answered: 1. When I open my Excel Database I get the following Message: "This workbook contains links to one or more external sources that could be unsafe." I get ...
That worked perfect thank you so much for your help.
I take it there is no way to get rid of that message that keeps popping up since there is nothing addressing that issue. I can live with that though
I take it there is no way to get rid of that message that keeps popping up since there is nothing addressing that issue. I can live with that though
Do you want to keep the links, but without the warning, or would you like to get rid of the links?
- I want to keep the links as each one links to another report I just want to get rid of the warning if that is possible. Also I will need to know where the code would go and what the code would be as I am not that good at doing VBA
Select File > Info.
On the right hand side, you should see 'Edit Links to Files'.
Click on this link.
In the 'Edit Links' dialog, click 'Startup Prompt...'
Choose the second or third option, according to your preference.
Click OK.
- I don't have "Edit Links to Files" I tried to do a copy paste to show you what opens but it did not work.
Here is some of what is on the right side of the page
Status - categories -hyperlink Base - Related Documents - tags - template
on the left side there are 2 boxes that are highlighted yellow:
Security Information - active content might contain malware and other security hazards. The active content in this file is allowed to run because it is a Trusted Document, and policies or trust center setting aren't restricting it.
Trust center Settings
Learn more about active content
Learn more about trusted documents
I don't know if I need to go into one of the topics above.
Please advise