Data source reference is not valid in Pivot Table

Recently, I have been getting this error messge when I try to create a Pivot Table from Table in excel 2007. I have checked every single column and there is no empty one. I am really getting annoyed as the same data which have imported from CRM system some times work and other times does not work. If I also convert my data in to a range and try to insert PT, I get the same error.
Please help!

Comments
There are 2 comments. Login or register to view them.

Some thoughts

paulwakefield1 |

Data source reference is not valid in Pivot Table

Cantona1 |