Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA Pivot table fetch records
I have a table 'tbl_Final' in MS Access 2007 where the data is used
and cached in a pivot table found in the 'Data' worksheet in MS Excel 2007. In this MS Excel 2007 workbook, I have various worksheets reports which links to the pivot table values found 'Data' worksheet. I linked formulae in one of the cells found the worksheet reports, looks like this: =GETPIVOTDATA("Amount",Data!$B$4,"Month", 2,"Year","2008","Scenario","Budget") Lets say the cell value total is: 1000 So, In pivot: 1000 In worksheet report: 1000 If I go to pivot table where this '1000' value is and double click on this value, MS Excel builds another worksheet with all the individual transactions that makes up the '1000' value. If I then go to the '1000' value found in the worksheet reports; this link, when double clicked, will NOT build another worksheet with all the individual transactions that makes up the '1000' value. Question: Is it possible using VBA to build some functionality in MS Excel to allow the '1000' value found in the worksheet reports, when double clicked, on that cell to build another worksheet with all the individual transactions that makes up the '1000' value? Prehaps its like querying from MS access to MS Excel using the cell parameters ine the SQL. I'm not sure how to write this MS Excel VBA logic if doable. Any help appreicated Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel VBA Pivot table link cell fetch records | Excel Programming | |||
2007 Excel Pivot Tables - Error Message too many records? Help | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "too many records" Excel 2007 | Excel Discussion (Misc queries) | |||
2007 pivot table too many records | Excel Discussion (Misc queries) | |||
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet | Excel Programming |