+ Reply to Thread
Results 1 to 2 of 2

GETPIVOTDATA Link to External Pivot Table

  1. #1
    Bill Ba
    Guest

    GETPIVOTDATA Link to External Pivot Table

    In a workbook, I made a GETPIVOTDATA formula to link to a Pivot table in
    another workbook, but...

    If I open the workbook with the formula while the pivot table workbook is
    closed, and then update links, I receive the dreaded "#REF!" error in the
    cell where the formula is. (By the way, the fomula points to the correct
    full path of the starting cell of the pivot table, and the formula works
    correctly when the pivot table file is open.)

    Is there any way to make GETPIVOTDATA to read pivot tables in other
    workbooks that are closed???

    I would prefer to use the GETPIVOT DATA formula rather than formulas
    directly referencing cells in case the table format changes.

    Thanks for any advice.



  2. #2
    Debra Dalgleish
    Guest

    Re: GETPIVOTDATA Link to External Pivot Table

    The GetPivotData function returns an error is the other workbook is
    closed, as described in the following MSKB article:

    http://support.microsoft.com/kb/299303/en-us

    Perhaps you could create the GetPivotData in the other workbook, and
    link to the cell that contains the result.

    Bill Ba wrote:
    > In a workbook, I made a GETPIVOTDATA formula to link to a Pivot table in
    > another workbook, but...
    >
    > If I open the workbook with the formula while the pivot table workbook is
    > closed, and then update links, I receive the dreaded "#REF!" error in the
    > cell where the formula is. (By the way, the fomula points to the correct
    > full path of the starting cell of the pivot table, and the formula works
    > correctly when the pivot table file is open.)
    >
    > Is there any way to make GETPIVOTDATA to read pivot tables in other
    > workbooks that are closed???
    >
    > I would prefer to use the GETPIVOT DATA formula rather than formulas
    > directly referencing cells in case the table format changes.
    >
    > Thanks for any advice.
    >
    >



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


+ 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