Calendar years

%3CLINGO-SUB%20id%3D%22lingo-sub-1973825%22%20slang%3D%22en-US%22%3ECalendar%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1973825%22%20slang%3D%22en-US%22%3E%3CP%3ESaved%20a%20calendar%20and%20integrated%20other%20worksheets%20with%20Jobnames%20and%20bid%20dates%20for%202020.%26nbsp%3B%20I%20want%20to%20create%20a%20new%20copy%20of%20this%20calendar%2Fworkbook%2C%20clear%20all%20of%202020%20data%2C%20and%20change%20the%20year%20to%202021.%26nbsp%3B%20However%2C%20the%20cell%2C%20is%20no%20longer%20a%20dropdown%2C%20or%20live%3F%20cell.%26nbsp%3B%20When%20I%20first%20created%20this%20file%2C%20i%20could%20click%20the%20up%20or%20down%20boxes%20next%20to%20the%20cell%20and%20it%20would%20change%20the%20year.%26nbsp%3B%20However%2C%20now%20it%20won't%20change.%26nbsp%3B%20and%20if%20i%20manually%20input%2Fchange%20to%202021%2C%20the%20calendar%20headings%20don't%20update.%26nbsp%3B%20I%20believe%20it%20might%20have%20to%20do%20with%20the%20name%20manager%2C%20but%26nbsp%3B%20I%20am%20not%20sure.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1973825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

0 Replies