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 star...
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.