+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Calculated fields in Pivot formulas breaking

  1. #1
    Registered User
    Join Date
    05-06-2009
    Location
    limerick pa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Calculated fields in Pivot formulas breaking

    Hi I have a series of formulas in an Excel Spreadsheet that break in various fashions when the Table they are linked to is modified in any way.

    Exampe, I add a column to a table to include new data, and 2 of my formulas will inbvariably break. They have nothing to do with the new data, it just seems that if the table gets modified formulas break. Since I have dozens of formulas in my spreadsheet, I then have to get a list of all formulas, see what is broken, and rebuild the formula. I do this all the time, and its exasperating.

    Anyone know a better way? (Macros are NOT an option).

    Example:

    Calculated fields:
    a=pca
    b=pia
    c=tca
    d=tia
    Qualified Visits = Total - a-b-c-d

    Rate=Qualified Visits / Clicks
    QV Rate = Media/Qualified Visits


    If anything is modified in the Table, the Qualified Visits formua display #NAME?-#NAME?-#NAME?-#NAME?-#NAME?
    and then all formulas relating to Qualified Visits break.

    This is just one example. I cannot figure out what this happens at all.

    Any thoughts?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Calculated fields in Pivot formulas breaking

    This could better answered by allowing us to take a look at your workbook. Can you upload a copy (scrubbed to remove any sensitive data, of course)?

    What type of referencing are you using in your formulas? Post a sample of the actual formulas used.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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