Can you post one of your GETPIVOTDATA attempts?
I can then ask you questions about its arguments
and help you uncover the source of your problems.
Mark
I have two rows called account No. (5 digit number) and account names. I have dates split into months across the top.
Example of formula are:
=GETPIVOTDATA(Sheet1!A4:N285,"50110 Jul-01")
=GETPIVOTDATA(Sheet1!A4:N285,Equal Share 7/1/2001)
Equal Share is one of the account names and 7/1/2001 was just trying the date in a different format. Interestingly the bottom formula comes up as acircular reference which seems very odd.
Any suggestions you may have would be great.
Cheers
Dan
Tryed both of these and they come back with showing #REF!.
I'm gonna conclude that you have applied a "mmm-yy"
format to what would otherwise be dates such as
7/5/01, 7/24/01, etc. If I've guessed correctly
you have two alternatives...
1. Add a month column to your data list that
contains the formula, =TEXT('Date',"mmm-yy"),
which will convert your 'Dates' into a textual
Month value. Then change your formulas to...
=GETPIVOTDATA(Sheet1!A4,"50110 Jul-01")
=GETPIVOTDATA(Sheet1!A4,"Equal Share Jul-01")
2. Group your dates into months and years using
the Data | Group and Outline | Group... menu
command, and then change your formulas to...
=GETPIVOTDATA(Sheet1!A4,"50110 2001 Jul")
=GETPIVOTDATA(Sheet1!A4,"Equal Share 2001 Jul") Tryed both of these and they come back with showing #REF!. : =GETPIVOTDATA(Sheet1!A4,"50110 7/1/01")