I am getting an error message when refreshing all pivot tables... it is stating that the pivot data file could not be opened... I don't have any links and the data reporting from my pivot tables is within my current file... is there a way to find and delete whatever it is looking for because it doesn't need to look for it anymore?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Tables, Refresh All
- Thread starter Coach3131
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Hi,
It's not so easy to say what's going on here.
AB
Another Question: I found the connection property in the object model for the pivotcache object, but I could find no way to get its value. Is anyone aware of a means to get this value -- i.e. (pseudocode), | for each pivotcache in pivotcaches | debug.print pivotcache.connection | next pivotcache |
It's not so easy to say what's going on here.
What do you mean by "refreshing all pivot tables"? Is this a macro?
AB
Another Question: I found the connection property in the object model for the pivotcache object, but I could find no way to get its value. Is anyone aware of a means to get this value -- i.e. (pseudocode), | for each pivotcache in pivotcaches | debug.print pivotcache.connection | next pivotcache |
Last edited:
Upvote
0
Similar threads
- Question
- Question
