•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot Table - can't see PivotTable Analyse, and can't see Pivot Table options when right clicking
Our take
If you're experiencing issues with accessing the PivotTable Analyze options and right-click functionalities in a large Pivot Table, you're not alone. With a dataset comprising 20,000 rows and a Pivot Table output of 25 columns by 250 rows, complexities can arise. While the GETPIVOTDATA formula continues to function, it's important to note that other Pivot Tables in your workbook remain operational. This situation invites a closer examination of your current setup to optimize your data management experience. Explore potential solutions to regain full functionality.
Large Pivot table output: 25 columns x 250 rows. Using 20000 rows of input data from another sheet.
Formula: GETPIVOTDATA still works
Edit: Other Pivots on different sheets in the workbook still work.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Pivot Table Show Details not working, any idea?Hi there, I am facing with a quite unique issue I think. There are some pivots in an Excel file that we use for internal reports for the AP team. The issue is that for the pivots there are several filters applied on, like Intercompany filter or "is the amount negative" etc. but there is the most important one is the Vendor filter, there are numerous vendors excluded, and I was like okay let me just recreate the pivot from the ground, but that would take a bit too much due to the vendor filter. The main problem is that the show details is not working, if I execute a double click on the pivot's total cells then it is loading for a 0.1 second and then nothing happens. If I try it after I close and reopen the file, then it loads for 2 seconds, with the botom right text saying "Reading Data" but then nothing, same results. It is a connection based pivot table, I tried to copy and paste into a new sheet the Pivot, didn't work, I tried to Save & Repair the file, it didn't work. Any idea? submitted by /u/Strange_Cell1142 [link] [comments]
- PivotTable only goes to row 70I’ve inherited an excel spreadsheet from an old employee at my work and they’ve got a pivot table in it which is set to go to row 70. Data is now well below that row so I’m trying to expand it to include up to row 200. I’ve clicked “resize table” and put in the right numbers however it says I need to turn off auto filter but I can’t figure out how to do this as everything I press won’t make it work anyway! Any advice would be appreciated submitted by /u/j3ssicamar3e [link] [comments]
- finding pivot table with the wrong data sourceAt some point a data set was moved (instead of creating a new copy) to another excel file in order to share with another team, and at that time a number of pivot table data source links went with it. I have found most of them and fixed the link back to a source contained within the workbook, but some are still pointing to the moved (and no longer available) data . I know how to look at individual pivot tables to find their data sources, but i have been unable to locate the offending pivots. Is there a way to search for pivot table data sources without knowing where the pivot tables are? submitted by /u/derekisber [link] [comments]
- Formula to re-arrange data set to be able to create a pivot table.I am looking for a formula to re-arrange the data I have: https://preview.redd.it/vkdes6wyxqrg1.png?width=345&format=png&auto=webp&s=a30397f809384603a701af85ad807c46b9bdacf4 This is the format I want: https://preview.redd.it/43zatlm0yqrg1.png?width=450&format=png&auto=webp&s=902ea4ac22cb499f567009801ba6def7766b929e I need to do this the pay data of approx. 100 employees, each employee has a different set categories so the number of times the name needs to repeat will vary. I want to do this so I can create a pivot table, any suggestions are welcome. Using Excel365 Desktop - Beginner to intermediate level knowledge Thank you in advance. submitted by /u/Ok_Chicken_590 [link] [comments]