Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Affect a new connection to a pivot table Philippe Cand Excel Discussion (Misc queries) 0 March 17th 10 09:49 PM
Pivot Table loses Data Connection Dead.Zone Excel Discussion (Misc queries) 0 July 7th 09 02:45 PM
Pivot Table Connection String - How to hide it? fijieddie Excel Discussion (Misc queries) 4 March 4th 09 04:46 AM
Copy pivot table and get rid of connection araki Excel Discussion (Misc queries) 3 March 8th 06 01:59 AM
Pivot Table Connection Steven Taylor[_3_] Excel Programming 5 November 19th 03 03:40 PM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"