Show Details of all cells at once

Hi Folks,

I tried using a VBA code in another thread but it didn't work for me. It was this one:

Please Login or Register  to view this content.

I have a pivot table in which the data is 35 columns wide and 45 rows long and I need to show all details in one sheet. There are 968 cells of data so of course going one by one is not an option. Each cell detail is 726 rows long, which means that the data should be 702k rows long which is fine.

Can anyone help me with this?

I can't share a file because it's proprietary and sensitive but any guidance would be appreciated.

Thanks!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi David,

So you have a bunch of data that you've done a pivot table on. The Pivot is 35 columns and 45 rows. If you double click on a cell in the Pivot Table it will create a new sheet showing all the data that made up that cell's data. When I do this I look at the data and then delete the new sheet and double click on another cell to "showall" for it.

Why do you want to "show all" if you need all of it, when it is already in the data that created the pivot table you started with in the first place??

That is the point. To make a pivot table, you need the data expanded out. This "expanded out" is the same as what you get when you "show all". What I think you are really looking for is a filter of the original data to get the format you need.

Look at AutoFilter for your data and see if that is more of what you need.

Hi,

If you make sure you have grand total rows and columns displayed and all filters removed from the pivot table, double-click the final grand total cell - i.e. the one in the bottom right corner of the pivot table. As long as the data has been stored with the pivot table, it should produce a sheet showing all of the source data.