| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pointing lots of Excel Pivot Tables at a Different Cube file
I have an excel front end (with lots of pivot tables) that looks at data from
a cube from access. I want to use the same front end sheets (that contain lots of pivot tables), but want them to look at a different cube. At the moment, I have to change this in each pivot table in each sheet separataly. I have about 50 sheets. I want to be able to point each one to the different cube. Is there an easy way to do this??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Pivot Tables using a CSV file | Excel Discussion (Misc queries) | |||
| Minimize the size of a file that contains multiple Pivot Tables | Excel Discussion (Misc queries) | |||
| minimize the file size in a ppt with collections of many pivot tables | Excel Discussion (Misc queries) | |||
| Excel links are pointing to the same file | Links and Linking in Excel | |||
| Large Excel file size, no pivot tables | Excel Discussion (Misc queries) | |||
Linear Mode
