Forum Discussion
PROBLEM RESOLVED - #REF! Error When Inserting Any Year One Month Calendar
I was trying to insert an Excel provided One Month Calendar into the Project Plan template spreadsheet, but it is not formatting the cells correctly. I created a new tab and did a right click insert...
Here's a suggestion, try opening a new workbook, go to File> and click 'More Templates> and search that template. if you want to transfer it to another workbook or add a copy of that sheet, just copy/move the original sheet of the calendar. Instead of right clicking to insert a new sheet of any year one month calendar year template. If you do it right, you'll not getting that error. I don't what's causing that problem when you tried to insert that template by right click the sheet tab.....
