98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Pivot tables
Resolved · Urgent Priority · Version 2003
Pivot tables
I am trying to create a pivot table from a range of excel data. I have selected and named all the data ranges used in the table, and there are no blank cells within the selection. When I get to the end of the pivot wizard and click 'finish', excel shows the following message:
'The pivot table filed name is not valid. To create a pivot table report, you must use data that is organised as a list with labeled columns. If you are changing the name of a Pivot Table field, you must type a new name for the field.'
What am I doing wrong?
RE: Pivot tables
Hello Andy
Thank you for your question and welcome to the forum.
When you get to the second step of the wizard where it asks you for the data source for the pivot table, what are you entering into the box at this stage of the wizard?
Kind regards
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |