1 min readfrom 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

submitted by /u/j3ssicamar3e
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com