Reference is not valid for Pivot tables

C

Cyanxerxes

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.
 
C

Cyanxerxes

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
List all tables, including document structure 0
Excel 2007 pivot table using analysis services cube as data source 0
Help creating a search form in Access XP 0
Embedded Excel into Word with Tables 0
Setting column width in a table with a macro is not working 0
Pivot tabel field name not valid in 2007, was in 2003 0

Top