MS Excel VBA Pivot table link cell fetch records

[asxastro]

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.

 

[peter dunn]

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 use
and cached in a pivo
table found in the 'Data' worksheet in MS Excel 2007

In this MS Excel 2007 workbook, I have various worksheets report
which links to the pivot table value
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: 100

So, In pivot: 100
In worksheet report: 100

If I go to pivot table where this '1000' value is and double click o
this value, MS Excel build
another worksheet with all the individual transactions that makes u
the '1000' value

If I then go to the '1000' value found in the worksheet reports; thi
link, when double clicked, will NO
build another worksheet with all the individual transactions tha
makes up the '1000' value

Question: Is it possible using VBA to build some functionality in M
Excell to allow the '1000' value foun
in the worksheet reports, when double clicked, on that cell to buil
another worksheet with all the individua
transactions that makes up the '1000' value

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

Any help appreicate

Many thanks in advance.

Previous Posts In This Thread:

MS Excel VBA Pivot table link cell fetch records
I have a table 'tbl_Final' in MS Access 2007 where the data is use
and cached in a pivo
table found in the 'Data' worksheet in MS Excel 2007

In this MS Excel 2007 workbook, I have various worksheets report
which links to the pivot table value
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: 100

So, In pivot: 100
In worksheet report: 100

If I go to pivot table where this '1000' value is and double click o
this value, MS Excel build
another worksheet with all the individual transactions that makes u
the '1000' value

If I then go to the '1000' value found in the worksheet reports; thi
link, when double clicked, will NO
build another worksheet with all the individual transactions tha
makes up the '1000' value

Question: Is it possible using VBA to build some functionality in M
Excell to allow the '1000' value foun
in the worksheet reports, when double clicked, on that cell to buil
another worksheet with all the individua
transactions that makes up the '1000' value

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

Any help appreicate

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/tutorial...9-082c24acd999/how-to-annotate-images-fr.aspx