TinaP
Well-known Member
- Joined
- Jan 26, 2005
- Messages
- 528
Please accept my apology in advance, this is going to be a long post.
I have a large workbook which gets sent to our board of directors every month. The data is downloaded from our mainframe and compiled in a useful form by a macro. It has worked well for the past seven years, with occasional tweaks necessitated by examiners or management requests. Among other things, there is a pivot table on one sheet generated from data on another sheet. Last month, management asked me to add another field to a data sheet and, subsequently, the pivot table. I added the field, adjusted the macro, and everything worked great—until I tried to balance it. After adding the column, the new field will not show in the Field List. The new field was added in the middle of the data and the fields to the left and right show just fine.
What I’ve tried:
Other useful info:
What am I missing? Management is not aware of the problem and I’d like to fix it before they find out.
I have a large workbook which gets sent to our board of directors every month. The data is downloaded from our mainframe and compiled in a useful form by a macro. It has worked well for the past seven years, with occasional tweaks necessitated by examiners or management requests. Among other things, there is a pivot table on one sheet generated from data on another sheet. Last month, management asked me to add another field to a data sheet and, subsequently, the pivot table. I added the field, adjusted the macro, and everything worked great—until I tried to balance it. After adding the column, the new field will not show in the Field List. The new field was added in the middle of the data and the fields to the left and right show just fine.
What I’ve tried:
- I have refreshed the pivot cache repeatedly.
- The named range which I’m using as the pivot table data source selects all of the data.
- I have deleted and re-created the pivot table.
- I have deleted and re-created the pivot table worksheet and the data sheet.
- I have been researched this online for the past two days. I found a tool/macro at http://www.contextures.com/xlPivot11.html that leads me to believe the data from this past month isn't being absorbed in the pivot cache, but I can't figure out how to get it to work.
Other useful info:
- I’m using Windows 7 Professional, Excel 2010.
- The additional field shows on another computer using Windows 7 Professional, Excel 2016. Swapping computers is not an option.
What am I missing? Management is not aware of the problem and I’d like to fix it before they find out.