+ Reply to Thread
Results 1 to 1 of 1

Using GETPIVOTDATA with pivot field sums

  1. #1
    Registered User
    Join Date
    03-04-2005
    Posts
    34

    Using GETPIVOTDATA with pivot field sums

    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:

    Please Login or Register  to view this content.
    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.
    Last edited by mike703; 10-05-2012 at 02:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1