Convert a Pivot to a Raw Data

[shaibn]

Hi,

I have received a pivot table sheet where the raw data is not available (I have no other sheets with the raw data of it).

Is there any way that I can convert the pivot table to a raw data, this is when I do not have the source in hand?

Thanks.

[PeteABC123]

Copy, paste as values.
Pete

[dflak]

If you go to any cell in the pivot table and double click on it, Excel will open a new sheet with the source data that went into the computation of that cell. So if you have a grand total of both rows and columns and double click on it, you should get the complete source data.

[shaibn]

As said, I do not have the 'back end' of the data. The only available data i have is done in a pivot table. I don;t have the raw data, hence there is no way to double click on the pivot table nothing happens.

[scottiex]

Something like this?

Please Login or Register  to view this content.

I have one that handles multiple headers etc but maybe this is all you need.

[shaibn]

Thanks Scottiex for the coding!

Can you direct me where this should be placed in Excel?

Thanks!

[scottiex]

Ok I suggest you record a macro with nothing in it.
(view - macro - record macro then click Ok then click stop recording)

Now press alt F8 and find that macro and edit it.

replace that code with what I have.

After that click options and give the code 'hot key" (a key code that will make it happen maybe ctrl shift Q or something like that)