General discussion

Locked

Need some help with Microsoft Excel

By rjasper ·
I am not very agile in excel... but about two weeks ago i created a pivot table for a huge worksheet and today it would not update the data in the pivot table. I deleted the old pivot table and went about creating a new one. When i attempted to make a new one i got all the way through the pivotTable wizard. When the wizard was closing (which would have been when the information would have been put into the table) i got a message that read

"The pivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field."

any ideas?... i need to get this thing back up and it was very weird that it all of a sudden wasnt working. please help...

Thanks
Ryan

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Define the range

by cholt2064 In reply to Need some help with Micro ...

one of the steps the wizard leads you through should ask you to identify the range where your data is located. Delete the text in this box and select the range of cells where your data is found. Also, make each column has a title

Back to Community Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums