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
Excell 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?

I'm not sure how to write this MS Excel VBA logic if doable.

Any help appreicated

Many thanks in advance.

Sorry to get your hopes up but my reply is not for the problem you had but rather a query about whether you solved this as I want to do the same thing that you asked about.



asxastro wrote:

MS Excel VBA Pivot table link cell fetch records
08-Dec-09

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
Excell 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?

I am not sure how to write this MS Excel VBA logic if doable.

Any help appreicated

Many thanks in advance.

Previous Posts In This Thread:

On Tuesday, December 08, 2009 9:46 AM
asxastro wrote:

MS Excel VBA Pivot table link cell 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
Excell 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?

I am not sure how to write this MS Excel VBA logic if doable.

Any help appreicated

Many thanks in advance.


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Annotate Images from a database in a web page
http://www.eggheadcafe.com/tutorials...images-fr.aspx