98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Pivot Tables
Resolved · High Priority · Version 2007
Thu 30 Sep 2010, 14:33
Edited on Thu 30 Sep 2010, 14:43Delegate Claire said...
Claire has attended:
Excel Advanced course
Pivot Tables
I am trying to create a new PT but I keep getting the following message -
The pivot table file name is not valid. To create a pt you must you data that is organised as a list with labeled columns
I'm confused as mine are labeled????
its ok I have sorted it now!!!!!!!! Phew
Thu 30 Sep 2010, 16:55Trainer Andrew said...
RE: Pivot Tables
Hi Claire
Thank you for your question - glad you got it all sorted.
Sometimes Excel is unsure of the range of cells to use as the source for your pivot table. Make sure you have clicked into the source data before choosing to pivot. Even better would be to highlight the range of cells including labels then start the pivot process (although most times this is not necessary).
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
Thu 7 Oct 2010: Automatically marked as resolved.
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
