Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getpivotdata problem
Hoping you can help.
I have a Getpivotdata function as per below that successfully returns the relevant data for all of my records with the exception of one. I believe this is down to the data itself but as this is based on query results from a core system I can't change this data. The Data specifically in question is in cell B43 within my Reports sheet and contains "US & Canada". I believe that it's the & that is causing the problem, is there anyway I can adapt my function to cater for this being valid? Thanks, Al. C43 (Reports Sheet): =GETPIVOTDATA('Remedy Reports'!B$182,$C$32 &" " & "Sum of " &Report!$C$5 &" " &Report!$B43) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA problem | Excel Discussion (Misc queries) | |||
Problem with getpivotdata function | Excel Discussion (Misc queries) | |||
getpivotdata refresh problem | Excel Worksheet Functions | |||
GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions | |||
GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions |