•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
#rows.com