ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Restoring fields in a pivot table (https://www.excelbanter.com/excel-worksheet-functions/107993-restoring-fields-pivot-table.html)

Philip

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

Thank-you,



David Billigmeier

Restoring fields in a pivot table
 
Click any cell within your pivot table
<Data
<PivotTable and PivotChart Report
Click "Back"
Expand the data range to include the extra fields

--
Regards,
Dave


"Philip" wrote:

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

Thank-you,



Philip

Restoring fields in a pivot table
 
Thank-you very much.

Philip

"Philip" wrote:

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

Thank-you,




All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com