Restoring fields in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I deselected all but one field in a pivot table to do some analysis. How do I
recover the original fields?

Thank-you,
 
Click any cell within your pivot table
<Data>
<PivotTable and PivotChart Report>
Click "Back"
Expand the data range to include the extra fields
 
You must log in or register to reply here.

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

custom field with custom formula in pivot table! 2
Sorting the pivot table field list 4
Size of file with pivot table 2
Pivot using 250,000 rows of data in Excel? 1
Pivot Table Defaults 1
grouping dates in a pivot table 1
Pivot Item Displaying Incorrect Value? 1
Missing values from a pivot table field 1

Back
Top