Glad you solved the problem, and thanks for describing what you did.

Michael S wrote:
Agrhhhh!
It was as simple as concatenating empty string at the end of the
reference... Like A44&""
Somehow value in the pivot table cell was considered to be a string, but in
A44 - to be a number...

Michael

"Debra Dalgleish" wrote:


You can use references to cells outside the pivot table. Is there a
valid department name in cell A44?

Michael S wrote:

When using GetPivotData in new format (field-name pairs) I can't use as a
reference for a name the cell that is NOT WITHIN pivot table.
Let's say I have pivot table in range A1:C4. Then
GetPivotData("Total",$A$1,"Department",A3) is valid reference, but
GetPivotData("Total",$A$1,"Department",A44) is invalid...
I saw in couple of places (even http://www.contextures.com/xlPivot06.html )
suggestion to use external (to pivot) cell in the formula, but it looks like
GetPivotData can take only cells INSIDE pivot area as reference.
Am I wrong? Please, say I am...
Michael


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html