I am currently updating a summary sheet that uses data linked to pivot tables. I just ran into an issue as I have used the sum function within the pivot table to provide the sums of each set of data (BUDG, BASE) contained within a single pivot field (BUDTYPE). When trying to link to the total excel returns the following formula:
This produces a #REF error and would like to find out it anyone out there knows of a work around?? I am only trying to pull the "BUDG" total.
Please Login or Register to view this content.