I have a pivot table but have lost my original data.
What can I do to see the data in the original format (i.e. before I put it into a pivot table)
Thanks
I have a pivot table but have lost my original data.
What can I do to see the data in the original format (i.e. before I put it into a pivot table)
Thanks
You could make sure that all page fields are displayed as all, no fields are hidden, make sure you have a Grand Total at the bottom of your pivot table and simply double click on this total, your original data should be displayed. There are two exceptions to this 1) If you have the option Save data with table unchecked you won't be able to drill down on the data or 2) The total number of rows of data exceeds 65,536 (the maximum rows of data in a sheet
You are a star
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks