| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Filter
I have a workbook with several sheets that has a pivot table per sheet. The
pivot tables access a sql database. The data is filtered on the period. The filter is hardcoded into Microsoft query. All the pivot tables uses the same filter, but very disparate data. Is there any way that I can use a variable in the query that references cells in the workbook? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
| Filter based on Pivot table | Excel Worksheet Functions | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Threaded Mode
