Blue1971
New Member
- Joined
- May 19, 2020
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Is there a way to make an PivotTable filter permanent?
I.e., prevent or discourage users from removing a filter from a PivotTable, since bringing in that intentionally excluded data would cause confusion.
The data source is a Microsoft Query Connection to an Oracle database. So in theory, I could add a filter to the query's SQL WHERE clause. That would work, but in this case, the connection is multi-purpose in this Excel workbook. So I don't want to pre-filter the connection, because I need the excluded data elsewhere in the workbook. So I would need to create an additional connection that includes the excluded data, adding clutter to an already complex workbook. And violating the DRY principle.
I.e., prevent or discourage users from removing a filter from a PivotTable, since bringing in that intentionally excluded data would cause confusion.
The data source is a Microsoft Query Connection to an Oracle database. So in theory, I could add a filter to the query's SQL WHERE clause. That would work, but in this case, the connection is multi-purpose in this Excel workbook. So I don't want to pre-filter the connection, because I need the excluded data elsewhere in the workbook. So I would need to create an additional connection that includes the excluded data, adding clutter to an already complex workbook. And violating the DRY principle.
