Forum Discussion
Calendar #REF error
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?
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.
