Hey, I've got a question that is a stumper for me. I have several pivot tables calling data from an external source. Sometimes the URL changes and the pivot tables reset. For example, filters are lost. Formatting of the tables are lost. They all have to be reworked. Any ideas how to prevent this from happening? Is there a way? Ultimately, would like to just change the URL without losing the formatting and filters.
-
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.
Chaning data source effect on pivot table
- Thread starter muelledg
- Start date
Similar threads
- Solved
- Question
