Saved a calendar and integrated other worksheets with Jobnames and bid dates for 2020. I want to create a new copy of this calendar/workbook, clear all of 2020 data, and change the year to 2021. However, the cell, is no longer a dropdown, or live? cell. When I first created this file, i could click the up or down boxes next to the cell and it would change the year. However, now it won't change. and if i manually input/change to 2021, the calendar headings don't update. I believe it might have to do with the name manager, but I am not sure.
