A calendar is not auto-populating when switching months!

[tylerariemasson]

I have a calendar created in excel. It pulls dates from the "Calendar_Items" tab. The calendar is auto-populating for the month of May, which is perfect. But when I switch months to June, only one entry from the "Calendar_Items" tab is populated on the calendar!? I have no idea how to fix this, I would have assumed that when I switch month, the calendar would auto-populate the same way.

[oeldere]

I did not study your file yet but the only value of june in column A is

row 29 02-06-20 F2R4 100,00

So to my opinion that is correct with your statement.

Probably you expect something else.

[Toonies]

it works fine as oeldere has already said you only have one specific June date in your Date column