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 thoughDo 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
