I have a Pivot Table on a "Pricing Sheet" tab. The data comes from the "Master title list" tab. The Master title list has 26 regular columns (A-Z) and 10 columns (AA-AJ) in a table with formulas. The entire range is named "Full List," so the pivot table data source is "FullList."
For some reason, the pivot table is not refreshing properly. If I right click on the data and select refresh, it works, but when I save the document and reopen, the refresh does not apply. I've tried selecting "Refresh data when opening the file" and that does not solve the issue. I've also tried just selecting the entire range of data instead of using the "FullList" name and it does not work. Any ideas?
For some reason, the pivot table is not refreshing properly. If I right click on the data and select refresh, it works, but when I save the document and reopen, the refresh does not apply. I've tried selecting "Refresh data when opening the file" and that does not solve the issue. I've also tried just selecting the entire range of data instead of using the "FullList" name and it does not work. Any ideas?