Share via

Sharepoint 2010 Group Calendar Overlay shows duplicate items

Question

Tuesday, May 3, 2011 12:52 AM

Hi,

I have setup a group calendar overlay in sharepoint 2010 to colour code each item based on resources. Everthing works fine but the main calendar shows the items twice i.e one colour coded event and the other in the normal green colour. How do I see only the colour coded event entry? So in my overlay calendars, I have set filters to show data by resource type. 

All replies (10)

Friday, May 13, 2011 4:46 AM âś…Answered | 1 vote

Ok, I found out how to fix this. The calendars are using different lists show they show twice. A workaorund is to create a custom field and give it a value say 1 in one of the lists. Then filter this in the main calendar and it works fine:)

Tuesday, July 31, 2012 8:19 AM | 1 vote

Hi Graham,

Believe it or not, this is the only entry that I've found through google about this problem.

I have a similar problem.

I have an overlay calendar which shows duplicate items.

One item works correct and when I click on it, it opens in a Sharepoint pop-up.

The other item opens in a new browser window and gives me a 404 not found error.

Do you know how to solve this? I don't get the above solution.

I see that if I use the month view than the item only shows once, but if I use a weekly (calendar) view, then the item shows twice.

I really have no idea what the problem is.

Hoping you can help me.

Thanks!

Thursday, May 15, 2014 1:10 PM | 7 votes

This is an old post, but there's not a lot of info to be found about the duplicate problem.
I found this site which helped, but it's burried near the end. 
http://summit7systems.com/color-code-calendar-events-in-sharepoint/

The default Calendar view shows all the events, then you're adding all the filtered views with colors on top of it.

To remove the duplicates, do the following:

  1. From the main "Calendar" view, click "Modify this View"
  2. In the Filter section, select the column/category you filtered the overlay views by and choose "is equal to"
  3. Leave the Value field blank and click OK

Since you're already filtering on this selected column to create the color overlays we can assume that column/category will always have a value in it. This new filter on the top-level "Calendar" view removes any events which do not have a value assigned already. Adding an event without a value will allow it to appear in the calendar still, but will not add it to any of the other color-filtered views. As a safety measure, you can simply require a value for that column/category.

Thursday, July 2, 2015 3:01 PM | 1 vote

To remove the duplicates, do the following:

  1. From the main "Calendar" view, click "Modify this View"
  2. In the Filter section, select the column/category you filtered the overlay views by and choose "is equal to"
  3. Leave the Value field blank and click OK

Since you're already filtering on this selected column to create the color overlays we can assume that column/category will always have a value in it. This new filter on the top-level "Calendar" view removes any events which do not have a value assigned already. Adding an event without a value will allow it to appear in the calendar still, but will not add it to any of the other color-filtered views. As a safety measure, you can simply require a value for that column/category.

This worked for me. Thank you

Wednesday, July 15, 2015 5:51 PM

I had a problem similar to @AlbertDeWolff's issue. We're using SPF 2010 fwiw.

Two near identical calendar entries showing in a calendar view, one of them you could click and edit, the other one would click but produce a SharePoint error in the dialog.

The two entries, as it turned out, were originally supposed to have been a single entry. I found out that the author of the invite, within her Outlook, had merely sent out an 'update' to her original invite. It is beyond me why SharePoint split this into multiple entries, but, it is definitely a bug.

Our calendar has versioning turned on. I'm foggy now, but, it seemed like if we rolled back the versioning on one of the items, it left us with the other item still in tact.

I created a datasheet view of the calendar and right-clicked the 'bad' item and deleted it. This allowed our Outlook client's to start working again (we had previously divorced our Outlook from SharePoint synch because this bug was crashing everything) and so we were able to reconnect our SP calendars to Outlook.

Friday, January 19, 2018 6:55 AM

Thanks Man. Its working for me.

Arun sahoo

Tuesday, January 23, 2018 5:18 PM

This is awesome even 3 years later! You rock. Thank you!

Monday, April 2, 2018 6:22 PM

Thanks mojoriesen....this worked for me!

Sunday, November 17, 2019 11:11 PM

This is the solution I have implemented and it's all working good.

1. Create a new column with the name of "ViewValue" with the number format and default value is 0.

2. Click on the Calendar Menu and Click on Modify View from Calendar Screen.

3. Select "Show Items only when the following is true:" under the Filter section

4. Show the items when column : Column Name is ViewValue is equal to 1

5. Click on OK. 

Monday, April 27, 2020 12:13 PM

This worked for me