Missing data when using drill down in Pivot Table

[Bearly]

I am a new user to Excel 2013 recently upgrading from 2003. I am using a Table which is linked to an external data source (SharePoint List). In the Sharepoint List there is a column which collects text data "Notes/Comment". The external data link works well and all the data from the SharePoint List is imported and updated as it is menat too.


I have then created a series of pivot tables to analyse the data and create reports, however when I use the drill down by double click a total field in the pivot table - the new worksheet that is created is returning black cells (entire column) in the "Notes/Comments" column. Other text columns work OK and there are no issues.

Can anyone help to identify the possible cause please?

 

[Bearly]

I have found the answer to this issue. The data comes from a SharePoint list. The "Notes/Comments" field in the SharePoint list is a multiple line text field which was set to Enhanced Rich Text. Once the settings were changed to plain text, the drill down in Excel 2013 started working correctly.