Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Pivot Table
G'day there One & All,
It's me, back again. I posted earlier about trying to build a report from the office's workbooks ("Thankyou" again to those who responded). These workbooks contain several sheets, each with a pivot table drawing information from a database cube. I've now copied 3 of these sheets to my own workbook so I have 3 pivot tables. I've written code to ask if the 3rd sheet is needed when the file is opened (it calculates yearly averages and will probably only be used once a year) so there are 2 pivot tables that try to update immediately. On loading my file, I get an "Object or Application" error which doesn't tell me a great deal. However since the code stops on "pt.PivotCache.MakeConnection" I'm guessing that there's an issue with the connection to the data source. I have no problem connecting to the source from the original sheets on the same machine, so the problem's not related to permissions or paths. Do I need to copy some other settings across to my workbook? I've not been able to find anything like that on Google, or in John Walkenbach's books and I don't know what I'm looking for anyway. This is the first pivot table I've tried to write code for, and the first I've dealt with that has an external data source. Any advice or pointers will be gratefully accepted. Thanks for listening, Ken McLennan Qld, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from a pivot table | Excel Programming | |||
Copying pivot table | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Copying & Pasting from Pivot Table | Excel Discussion (Misc queries) | |||
Copying formulas using Pivot Table data | Excel Programming |