Inserting different calendar months onto different worksheets in the same workbook?

Question

Inserting different calendar months onto different worksheets in the same workbook?

Administrative Assistant 1

Instead of having different Excel files for each of the different months of my calendar, I wanted to have them all enclosed in one worksheet, a different month for each tab at the bottom ("January 2020" on one tab, then "February" on the next tab, etc).

The first tab I create is great, the calendar is editable, dates are correct. However when I try to add the next month's calendar to a new worksheet w/i the same workbook, the 'new' worksheet calendar dates just say "REF!" . I know that means there's some error in the formula, but not my formula so I'm not sure if there is a fix for this?

Or, am I just going to have to have each month on an entirely different Excel file, clicking, opening / closing each file each time I want to see a different month?

Shiva Keshav Varma 426 Reputation points

2020-10-27T14:16:25.607+00:00

Could you please share the Graph API calls that you are using in a step by step process and also the screenshots where you are get unexpected results?
Administrative Assistant 1 Reputation point

2020-10-27T14:17:09.823+00:00

( Though we have it installed, my boss doesn't want to use his MS Outlook, fyi, that's why I'm doing it this way. )
Administrative Assistant 1 Reputation point

2020-10-27T14:48:54.26+00:00
when I r. Click on the new sheet, I choose "Insert", then "Any year one month..." calendar.

This is what is produced after I select it.

This is the same steps I followed to add the first month and it worked perfectly. When I add subsequent months to subsequent "sheets" within the same workbook, this is when I get the displayed "REF!" appearance where the dates in the calendar should be.

I do not know what the Graph API is.
Shiva Keshav Varma 426 Reputation points

2020-10-29T17:20:51.417+00:00

Please go through this document. Not all operations that you want to do may not be present through graph but these are the HTTP calls that MS Graph provides on excel. Please check it an see if it can help.

Your answer

Shiva Keshav Varma 426 Reputation points

2020-10-27T14:16:25.607+00:00

Could you please share the Graph API calls that you are using in a step by step process and also the screenshots where you are get unexpected results?
Administrative Assistant 1 Reputation point

2020-10-27T14:17:09.823+00:00

( Though we have it installed, my boss doesn't want to use his MS Outlook, fyi, that's why I'm doing it this way. )
Administrative Assistant 1 Reputation point

2020-10-27T14:48:54.26+00:00

when I r. Click on the new sheet, I choose "Insert", then "Any year one month..." calendar.

This is what is produced after I select it.

This is the same steps I followed to add the first month and it worked perfectly. When I add subsequent months to subsequent "sheets" within the same workbook, this is when I get the displayed "REF!" appearance where the dates in the calendar should be.

I do not know what the Graph API is.
Shiva Keshav Varma 426 Reputation points

2020-10-29T17:20:51.417+00:00

Please go through this document. Not all operations that you want to do may not be present through graph but these are the HTTP calls that MS Graph provides on excel. Please check it an see if it can help.

Share via

Inserting different calendar months onto different worksheets in the same workbook?

Your answer