I have 2 workbooks that contain identical data, 1 is hosted on sharepoint, the other is the "master" file that updates the Sharepoint version of the file. This is necessary due to the unsupported features in Excel Services in Sharepoint.
The first worksheet of both workbooks contains a pivot table (PTFailures). When items are filtered in the pivot table on the master, I would like to update the Sharepoint version to only display the same filtered items.
I already have code that replaces all the source data in the Sharepoint version of the file whenever the user "synchs" the 2 files. I need to add the code that will match up the pivot table filters.
I don't know how to loop through both tables at the same time to see if each pivot item is visible or not.
Could anyone advise?
Thanks!
Bookmarks