Pivot Table: Not all source records have been copied. ???

**oeldere** · 09-01-2013, 09:45 AM

Using excel 2007 and no problem at all.

Not with the data in Copleteness Matrix.

Not with the data in sheet 2.

I also removed the table into "normal data"

And after that just run a pivot table, without faillure pop up's.

**mrwhirlwind** · 09-01-2013, 09:59 AM

Originally Posted by oeldere

Using excel 2007 and no problem at all.

Not with the data in Copleteness Matrix.

Not with the data in sheet 2.

I also removed the table into "normal data"

And after that just run a pivot table, without faillure pop up's.

Thanks for your reply but I saved the file in XLS format and recreate the pivot table, the pivot table creates fine but when selecting the 'count of tenant' and a the new sheet is generated the messag 'not all source records have been copied' still exists.