Power Pivot Calendar Date range unable to update

%3CLINGO-SUB%20id%3D%22lingo-sub-1818783%22%20slang%3D%22en-US%22%3EPower%20Pivot%20Calendar%20Date%20range%20unable%20to%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818783%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Guys!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20i%20need%20some%20help%20and%20no%20where%20else%20to%20get%20this%20but%20here%20in%20the%20community%20of%20excel%20guru's.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20i've%20a%20power%20pivot%20calendar%20which%20ends%20in%202020%20and%20i%20would%20like%20to%20extend%20this%20till%20as%20far%20as%20possible%20(e.g.%202024).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20challenge%20is%2C%20after%20clicking%20the%20design%20tab%20and%20under%20the%20calendars%20group%20clicked%20the%20'date%20table'%20drop%20down%2C%20my%20%22Update%20range%22%20option%20is%20blurred%20out%20(meaning%20i'm%20not%20able%20to%20select%20it).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20i'm%20perplexed%20and%20would%20be%20ready%20to%20explain%20and%20reexplain%20this%20challenge%20i'm%20having%20as%20many%20times%20as%20possible%20for%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1818783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hello Guys!

 

Please, i need some help and no where else to get this but here in the community of excel guru's.

 

Please i've a power pivot calendar which ends in 2020 and i would like to extend this till as far as possible (e.g. 2024). 

 

My challenge is, after clicking the design tab and under the calendars group clicked the 'date table' drop down, my "Update range" option is blurred out (meaning i'm not able to select it). 

 

Please i'm perplexed and would be ready to explain and reexplain this challenge i'm having as many times as possible for help.

 

Thank you. 

0 Replies