Thread: Restoring fields in a pivot table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
  
Posts: 176
Default 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,


Reply With QuoteReply With Quote