ISSUE:
Duplicate items appear when viewing items in Datasheet view in SharePoint. This also happens when using the Export to Spreadsheet (Excel). If duplicate entries appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.
DESCRIPTION:
The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Export the file to Excel it shows the same rows three times in as sequence.
Resolution:
The affected lists have a Required lookup field which allows multiple values. If you have a view that does not include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected.
Our work-around was to create a specific Datasheet view with the field included. The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet. However, it's important to include the field in the view to avoid duplicates. Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.
The duplicates appear also when you try to Export to Excel. If you have a view that would be affected by the "Switch to Datasheet" duplicate problem, when you try to Export to Excel, it will also appear.
Note : Please check with the Admin of the list before you uncheck multiple values.
Duplicate items appear when viewing items in Datasheet view in SharePoint. This also happens when using the Export to Spreadsheet (Excel). If duplicate entries appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.
DESCRIPTION:
The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Export the file to Excel it shows the same rows three times in as sequence.
Resolution:
The affected lists have a Required lookup field which allows multiple values. If you have a view that does not include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected.
Our work-around was to create a specific Datasheet view with the field included. The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet. However, it's important to include the field in the view to avoid duplicates. Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.
The duplicates appear also when you try to Export to Excel. If you have a view that would be affected by the "Switch to Datasheet" duplicate problem, when you try to Export to Excel, it will also appear.
Note : Please check with the Admin of the list before you uncheck multiple values.
No comments:
Post a Comment