Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivottable/pivotcache question
Hi,
Here is my problem: I have 5 reports with similar structure. All of them have pivot tables and vba code. All the pivot tables are based on data in the data sheet which is extracted from an Access db using vba code. The situation is one of the report's pivot table's data has exceeded 65536+ rows. So I ended up creating an external query with no vba code to create that pivot table. Because of this, this report is now out of whack with the other 4 reports. Is there any way I can add VBA code that will automatically extract data from the table in the Access db (using external data option) in all the 5 reports and the select will fetch data based on the report name? it would be of great help to me if somebody can point me in the right direction or give me some sample code. thanks kanan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivottable/pivotcache question
Instead of creating the reports from the extracted data, can you base
the pivot tables on the Access data directly? Kanan wrote: Hi, Here is my problem: I have 5 reports with similar structure. All of them have pivot tables and vba code. All the pivot tables are based on data in the data sheet which is extracted from an Access db using vba code. The situation is one of the report's pivot table's data has exceeded 65536+ rows. So I ended up creating an external query with no vba code to create that pivot table. Because of this, this report is now out of whack with the other 4 reports. Is there any way I can add VBA code that will automatically extract data from the table in the Access db (using external data option) in all the 5 reports and the select will fetch data based on the report name? it would be of great help to me if somebody can point me in the right direction or give me some sample code. thanks kanan -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Question | Excel Worksheet Functions | |||
PivotTable Question | Excel Discussion (Misc queries) | |||
PivotTable Question | Excel Discussion (Misc queries) | |||
Question about PivotTable | Excel Programming | |||
Setting CommandText property of PivotCache fails if cache has 1 PivotTable | Excel Programming |