Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot table
I have a pivot table and would like to view and change my SQL and database
link. Are there any way to open it to debug and verify it? I know that I can edit SQL from MS SQL if I use MS SQL to retreive data. I could not figure to open the cub file to deit and debug. Your inforamtion is great appreciated, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot table
The free Pivot Play add-in, located at Debra Dalgleish's website, may help:
http://www.contextures.com/xlPivotPlay01.html It allows you to view/edit the connection and SQL code for Pivot Tables that use external data sources. It has many other features, too. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Souris" wrote in message ... I have a pivot table and would like to view and change my SQL and database link. Are there any way to open it to debug and verify it? I know that I can edit SQL from MS SQL if I use MS SQL to retreive data. I could not figure to open the cub file to deit and debug. Your inforamtion is great appreciated, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot table
Thanks it does help,
Can I just modify DBQ and DSN in oqy text file using note pad? Thanks again, "Ron Coderre" wrote: The free Pivot Play add-in, located at Debra Dalgleish's website, may help: http://www.contextures.com/xlPivotPlay01.html It allows you to view/edit the connection and SQL code for Pivot Tables that use external data sources. It has many other features, too. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Souris" wrote in message ... I have a pivot table and would like to view and change my SQL and database link. Are there any way to open it to debug and verify it? I know that I can edit SQL from MS SQL if I use MS SQL to retreive data. I could not figure to open the cub file to deit and debug. Your inforamtion is great appreciated, |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
pivot table
In general, yes, you can modify saved query files.
Not sure about modifying the code for a .cub file, though. I didn't find a way to make any changes take. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Souris" wrote in message ... Thanks it does help, Can I just modify DBQ and DSN in oqy text file using note pad? Thanks again, "Ron Coderre" wrote: The free Pivot Play add-in, located at Debra Dalgleish's website, may help: http://www.contextures.com/xlPivotPlay01.html It allows you to view/edit the connection and SQL code for Pivot Tables that use external data sources. It has many other features, too. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Souris" wrote in message ... I have a pivot table and would like to view and change my SQL and database link. Are there any way to open it to debug and verify it? I know that I can edit SQL from MS SQL if I use MS SQL to retreive data. I could not figure to open the cub file to deit and debug. Your inforamtion is great appreciated, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |