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

when I try to create a pivot table using this small worksheet in the below link, I always get a message 'not all source records have been copied' yet it displays all source records? I have spent many hours searching for a solution with no success. Why would Excel give this error on such a simple task? it does not matter how many rows this data has 1-10000 same error, if I go to Insert -> Pivot table, select any fields in the pivot table. It counts correctly, it even displays the result correctly, but always give me the message 'not all source records have been copied' I really do not get it and any help would be amazing!

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.

I know it must be a simple change, but can not figure out how to make the pivot do the subtraction.