+ Reply to Thread
Results 1 to 2 of 2

How to copy down formula when references are in a pivot?

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    OSLO
    MS-Off Ver
    Excel 2003
    Posts
    66

    How to copy down formula when references are in a pivot?

    Hi!

    When I use formulas (find row) when the references are in a pivot I can`t copy the formula down. How can I do this?

  2. #2
    Registered User
    Join Date
    11-05-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: How to copy down formula when references are in a pivot?

    The way I get around this is to use the cell location rather than clicking on the cell in the pivot when putting together my formula. For example if the cell you need is b4, use b4 in your formula instead of clicking in the pivot and getting a cell reference like this: =GETPIVOTDATA("example",$B$102,"example",41).

    Does that make sense??

+ 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