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

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

How are you reconnecting? What filters are applied?

Tonny Olesen wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html