Pivot Table Data Connection
I am using ADO to Oracle to feed the PivotCaches for several Pivot
Tables in an Excel workbook. As there is some overhead involved in opening and closing the connection, I would like to recycle the connection and reuse it when the user changes a parameter that drives a necessary refresh to the pivotcache (maintainconnection = true). I would like to leave the connection open until the application closes. Is this possible? Is this possible with an ADO styled connection. I also use Oracle Objects for OLE to bring data to a workbook but have not been successful in connecting an Oracle OraDynaset to PivotCache / PivotTable. Any thoughts here? |
All times are GMT +1. The time now is 06:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com