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; see screenshot. As you can see, the formatting is not correct, not inputting the dates on the calendar.
2 Replies
- 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.....
ChristineKramlich Could you insert that same sheet in an empty workbook and upload that file here please? You can upload files if you click "Open full text editor" below the reply window. Then a box appears that says "Drag and drop here or browse files to attach"
