This is very strange and does not effect all machines. I have a file stored on a SharePoint site. If I send a link to the file in an email, some computers are getting:
Run-Time error '-2147417848 (80010108)':Method'_Default' of object 'SlicerCaches' failed
whenever they click an object that runs a macro reseting the Pivot Table Slicer filters.
Other machines run the code with no problem. Making it even stranger is that the machines with the error work fine if the file is saved to their local machine or sent to them as an attachement in an email. The error can only be recreated when the file is OPENed versus SAVEed after clicking the link.
The macro resetting the filters is shown below.
Bookmarks