Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Undo Excel Pivot Table
- Thread starter pcdaveh
- Start date
SkipVought
Programmer
Hi,
In the PivotTable right click and select Wizard.
Hit the [BACK] button until you get to Step 2 which references the source data.
At this point the SHEET & SOURCE DATA AREA are in view!
Skip,
In the PivotTable right click and select Wizard.
Hit the [BACK] button until you get to Step 2 which references the source data.
At this point the SHEET & SOURCE DATA AREA are in view!
Skip,
If you are looking to get at the raw data for just one of the entries in the Pivot table, then just doubleclick it, and as long as you have 'enable drill to details' checked in your table options, you will see a new sheet with all the data that sits behind just that record.
Regards
Ken.................
----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------
Regards
Ken.................
----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------
- Status