MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivotable Paths


Posted by Rob G on July 20, 2001 7:20 AM

I am having a problem with my pivotable source data. I have created a pivotable report on my personal space on a large corporate network. I now want others to summarize the data themselves, and for that I need to move the Access queries to a shared portion of the netwek, which changes the path of my source data in my tables. Is there a simple way of changing the path to my Access queries (just change the directories) without having to recreate the pivotables with the 'Get Data ...' feature.

Thanks
Rob


Posted by lenze on July 20, 2001 10:28 AM

After you move the Data Tables, Right click on your Pivot Table and rerun the Wizard. Use the Back buttin to get to the Panel where the path is changed.

Posted by Rob on July 20, 2001 11:00 AM

Right, I know how to do that...but is there an easier way of changing the path name without having to rerun the wizard and having to re-establish the connections and setup of the pivotables.


Posted by Mark W. on July 20, 2001 11:41 AM

Don't you establish a DSN using the ODBC Data Source
Administrator? If so, can't you select the database
pathname on the ODBC Microsoft Access Setup dialog?


Posted by Rob on July 20, 2001 12:03 PM

Hi Mark, thanks for responding!

I don't exactly understand what you mean!?
Basically what I'm asking, is how to change the path name for the source data attached to a pivotable, without having to use the pivotable wizard. Is there any place that you can edit the directory structure!

The reason why I ask is because my spreadsheet has many pivotables from many sources and I find it extremely tedious to edit each table and re-source it!

Looking for some advice!
Thanks,
Rob Don't you establish a DSN using the ODBC Data Source


Posted by Mark W. on July 20, 2001 12:15 PM

Is odbcad32.exe installed? Hi Mark, thanks for responding! I don't exactly understand what you mean!?


Posted by rob on July 20, 2001 12:41 PM

I believe it is! (Well, I found the file on the network, don't exactly know if it is installed or not) Is odbcad32.exe installed? : Hi Mark, thanks for responding! : I don't exactly understand what you mean!?


Posted by Mark W. on July 20, 2001 12:52 PM

You may want to take a look at the Excel Help
topic for "Specify a source to retrieve data from". I believe it is! (Well, I found the file on the network, don't exactly know if it is installed or not) : Is odbcad32.exe installed?