A little background: I have a function which requires some enhancements. This function as it currently exists is called to update pivot filters throughout my workbook based on a drop down list in which users select different lines of business. The code for this function is as follows:
The problem: I would like to include additional functionality that refreshes the pivot cache for one specific pivot table within this workbook. However, the new code below doesn't want to run. I get an error stating that the pivot table "NonBillableHours' is not defined... I feel like I am missing something basic here but can't put my finger on it. Thoughts? Suggestions?
Bookmarks