←Back to Beyond Market Intelligence
•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pivot Table Show Details not working, any idea?

Our take

It sounds like you're encountering a frustrating issue with your Excel pivot table, particularly with the "Show Details" feature not functioning as expected. Given that you have multiple filters applied, especially the critical Vendor filter, recreating the pivot might feel overwhelming. The fact that the details fail to load after multiple attempts, even after saving and repairing the file, suggests a deeper issue. Let's explore some potential solutions to troubleshoot this problem and restore functionality to your pivot table for your AP team’s internal reports.

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]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#rows.com#big data management in spreadsheets#conversational data analysis#cloud-based spreadsheet applications#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Pivot Table#Excel#Show Details