VBA GetPivotData error

**zonino** · 04-14-2009, 11:06 AM

Hi All,

I have something rather strange...

my code is:

Function returnExpenditure(projectDefinition, WbsElementEnd, recMonth)

Call getSettingsData

'concatanate the full WBS element from project definition and WBS End Fragment
FullWbsElement = Trim(projectDefinition) & "-" & Trim(WbsElementEnd)

ExpenditureInPeriod = Worksheets(sapPivotLocation).PivotTables(sapPivotName).GetPivotData("Value COCurr", "Per", recMonth, "WBS Element", FullWbsElement).Value

returnExpenditure = ExpenditureInPeriod

End Function

this works fine for everything apart from for some reason where I put "SINT" as the string for WbsElementEnd I'm not getting any value out, however there is definately applicable data!

any ideas??

**Andy Pope** · 04-14-2009, 11:45 AM

You will have to debug this one as without table and code it's impossible to say.

Start by checking the variables content. What do the following contain,
sapPivotLocation
sapPivotName
recMonth
FullWbsElement

Are they valid?

What happens if you use that information in the GETPCIVOTDATA function on a worksheet? Does it return the expected value.

**zonino** · 04-14-2009, 01:51 PM

all the variables are valid, and yes the GETPIVOTDATA function returns the expected value, and I've tried every troubleshooting method I know on it, I'm coming to the conclusion that its probably going to be more effort to hunt down the issue than recreate it in another sheet, fortunately its not very far down the development line yet...