4 ms·
You are writing about a problem that can be solved if you know what you are doing: Store your data in a table ( https://www.contextures.com/xlExcelTable01.html
by rvba 6y ago
You are writing about a problem that can be solved if you know what you are doing:
Store your data in a table ( https://www.contextures.com/xlExcelTable01.html https://www.contextures.com/xlExcelTable01.html ), then make a pivot table out of it.
You will never have problems with missing data.
In fact good practice is to add a check, just to see if your pivot table was refreshed and the data there matches the data in the source table. Just like you make tests in software.
- sjy 6y agoI always store data in tables for this reason, but last week I ran into a problem because someone else had added new data to my sheet somehow without the table range being automatically adjusted. The table looked visually correct but when you sorted or filtered it, the rows towards the bottom were not affected. So sadly, this is not a silver bullet, but it does help a lot.