Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Refreshing Pivot Tables linked to Oracle Datasource

I have created a Dashboard Report using Pivot Tables that feed values
to a Top Level spreadsheet. The project necessitates that the report be
auto-scheduled and run daily. Each pivot table is being fed by a query
in Access that is running against an Oracle production enviroment.
There are 28 pivot tables in all. I have written (and scheduled) the VB
script to open Excel and the specific workbook and created the macro to
Refresh all pivot tables in the workbook. What I need now is a way to
authenticate against the Oracle Environment once and refresh all of the
pivot tables in sequence.

Any help would be appreciated.

Marc

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
Refreshing multiple pivot tables jerredjohnson Excel Discussion (Misc queries) 2 May 2nd 06 06:23 PM
Pivot Tables are Automatically refreshing TMB Excel Discussion (Misc queries) 0 March 1st 06 06:41 PM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 04:50 PM
Renaming Cells linked to Pivot Tables gsimmons2005 Excel Discussion (Misc queries) 2 September 13th 05 03:51 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM


All times are GMT +1. The time now is 10:09 AM.

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"