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.

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.

I had downloaded the spreadsheet direct from my e-mail account, which for
some reason inserts numbers and % signs into the file name. When I saved the
file to my folders and reopened it, I had no problems with the pivot table,
apart from the 2007 version changes.

Regards.

"jcarr" wrote:

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.