![]() |
getpivotdata problem
I am trying to calulate a field based on pivot data...
Can anybody tell me why this results in an "Application defined or object defined error" ActiveCell.Offset(0, 1).Select ActiveCell.Value = 1.2 ActiveCell.Offset(0, 1).Select ActiveCell.Value = _ "=GETPIVOTDATA(""2006 F/cast"",$B$11,""Geo"",""Americas"",""Region"",""Cen tral"",""Partner Type""," & gpde & ",""Fulfillment"",""Rev Ptnr."")*(RC[-1])" (""2006 F/cast") is a CalculatedField -- Mike Watkins |
All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com