| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Pivot Charts, how to hide field values in second level filters? | Excel Discussion (Misc queries) | |||
| Pivot Charts, hiding field values in second level filters? | Charts and Charting in Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| pivot table | Excel Worksheet Functions | |||
Hybrid Mode
