I am having the same problem, let me know what you find out.

Thanks!

"Cyanxerxes" wrote:

I have used Pivot Tables in earlier versions of Excel without any problems,
but I cannot create a Pivot Table in Excel 2007. The data sorted in a list,
returns the message Reference is not valid. This used to appear if a column
label was missing.