Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Tables

Resolved · High Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

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

Excel articles

· Some Mouse Click Tips In Excel
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· Discover The Difference Between Line And XY Scatter Charts In Excel
· Chart Creation Simplified - in 4 Simple Steps
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips