•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PivotTable only goes to row 70
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]
Want to read more?
Check out the full article on the original site
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