•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PivotTable only goes to row 70
Our take
If you're facing challenges with a PivotTable that only extends to row 70 in an inherited Excel spreadsheet, you're not alone. Adjusting the table to include additional rows, like up to row 200, can enhance your data analysis. However, resizing the table may prompt an auto filter issue. To resolve this, you’ll need to turn off the auto filter feature. This article will guide you through the steps necessary to adjust the PivotTable settings effectively, ensuring your data is fully represented.
I’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
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#row zero#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#conversational data analysis#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#automation in spreadsheet workflows#intelligent data visualization#no-code spreadsheet solutions#AI-powered spreadsheet