I had the entire post drafted and then somehow deleted it, so this will be brief. I have no problems using this function when sourcing the normal fields in a pivot table, but it I attempt to source the "automated summation" fields, I receive the #REF error. Is there a way to successfully source these values as opposed to summing all the GetPivotTable data values. I need a more efficient process because the current process forces me to validate the presense of the data with the =(IF(ISNUMBER(MATCH
The problem with using the ISNUMBER is that I hit the Excel limit for characters in a cell and it does not work. Any suggestions are appreciated. Thanks
The problem with using the ISNUMBER is that I hit the Excel limit for characters in a cell and it does not work. Any suggestions are appreciated. Thanks