How to aviod reset of Pivot filters when reconnecting to database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large amount of Excel pivots feeding on MS Access databases.
However, these databases have moved location and I need to reconnect the
Pivots.
When I do this, I loose all the filters I have applied.
Does anyone know how to avide the resetting of these filters? It'll be a
great help to me as I have a lot of pivots...
Thanks,
Tonny
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table (column/row) label cache reset 4
date filter in a pivot table 1
Pivot Tables/Charts and common filter 1
filtering dates in a Pivot Table Report Filter 3
Multiple listboxes to update pivot table? 2
Need the grand total pivot table filtered worksheet? 1
Value filter missing in pivot table 3

Back
Top