Calendar #REF error

%3CLINGO-SUB%20id%3D%22lingo-sub-3012912%22%20slang%3D%22en-US%22%3ECalendar%20%23REF%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3012912%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20need%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20an%20Any%20year%20one%20month%20calendar%20template%20and%20which%20has%20come%20up%20with%20an%20error%20I%20can't%20fix.%3C%2FP%3E%3CP%3Eso%20I%20opened%20the%20document%20and%20the%20array%20for%20the%20calendar%20has%20removed%20the%20start%20day%20selection%20from%20the%20formula%20this%20has%20made%20all%20other%20formulas%20error%2C%20I%20cant%20figure%20out%20how%20to%20correct%20this.%3C%2FP%3E%3CP%3EHas%20anyone%20got%20any%20idea%20as%20to%20a%20solution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Untitled.jpg%22%20style%3D%22width%3A%20655px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329921i11E1D234220D9A0E%2Fimage-dimensions%2F655x368%3Fv%3Dv2%22%20width%3D%22655%22%20height%3D%22368%22%20role%3D%22button%22%20title%3D%22Untitled.jpg%22%20alt%3D%22Untitled.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3012912%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%3CLINGO-SUB%20id%3D%22lingo-sub-3013040%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20%23REF%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231988%22%20target%3D%22_blank%22%3E%40chazzer29%3C%2FA%3E%26nbsp%3BThis%20particular%20template%20is%20full%20with%20named%20formulae%2C%20named%20ranges%20and%20all%20sorts%20of%20other%20trickery.%3C%2FP%3E%3CP%3EAnd%2C%20as%20it's%20name%20suggests%2C%20it's%20a%20%22one-month%20calendar%22.%20Thus%2C%20not%20well%20suited%20to%20turn%20it%20into%20a%2012-month%20calendar.%3C%2FP%3E%3CP%3EIt's%20difficult%20to%20customise%2C%20easy%20to%20mess-up%20and%20difficult%20to%20repair.%20You%20picture%20shows%20both%20%23REF%20and%20%23NAME%20errors%2C%20suggesting%20that%20somewhere%20in%20the%20chain%20of%20named%20formulae%2C%20a%20named%20range%20is%20called%20that%20has%20been%20deleted.%3C%2FP%3E%3CP%3ECan%20you%20upload%20your%20file%3F%20Difficult%20to%20diagnose%20otherwise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I need help

 

I've used an Any year one month calendar template and which has come up with an error I can't fix.

so I opened the document and the array for the calendar has removed the start day selection from the formula this has made all other formulas error, I cant figure out how to correct this.

Has anyone got any idea as to a solution?

 

Untitled.jpg

1 Reply

@chazzer29 This particular template is full with named formulae, named ranges and all sorts of other trickery.

And, as it's name suggests, it's a "one-month calendar". Thus, not well suited to turn it into a 12-month calendar.

It's difficult to customise, easy to mess-up and difficult to repair. You picture shows both #REF and #NAME errors, suggesting that somewhere in the chain of named formulae, a named range is called that has been deleted.

Can you upload your file? Difficult to diagnose otherwise.