Forum Discussion
Delaney1382bill
May 24, 2022Copper Contributor
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 ...
HansVogelaar
May 24, 2022MVP
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")
- Delaney1382billMay 24, 2022Copper ContributorThat 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- HansVogelaarMay 24, 2022MVP
Do you want to keep the links, but without the warning, or would you like to get rid of the links?
- Delaney1382billMay 24, 2022Copper ContributorI 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