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 ...
2) Select the cell in which you want the current year.
Enter the formula =YEAR(TODAY())
Select the cell in which you want next year.
Enter the formula =YEAR(TODAY())+1
Select the cell in which you want the current month and year.
Enter the formula =TEXT(TODAY(),"mmmm, yyyy")
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.