Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Two-variable table brings the same value if I create a copy of the tab

    Why would Excel not calculate 2-variable data table correctly if I copy the tab? It keeps bringing the same value, which is the result of the formula reference.

    I am trying to create 2 sensitivity tables in one workbook. I created one, which works fine, then I copied the tab and copied over the sensitivity table into it. I used same inputs and formula that drive the table. First tab works fine. The second (copied tab) has the same value (result of the formula) across entire 2-variable table. In some of my attempts I got correct results in columns but then entire column has the same value.

    I have itirations enabled and autocalculation is on. The formula, upon which the sensitivity table is based gets its result from multiple feeding tabs, but the values that create the result of the formula are in the same tab where the table is located.

    Intrigued! Thank you for your help and any advice on those tables.....

    KGB

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Why do you have iterations enabled? I seem to recall reading that that is unpredictable with data tables.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Oct 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have other calculations that are predicated on circular reference. Do I need to disable iterations?

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I think I had misremembered it - it seems circular references are tolerated in data tables anyway.
    Does your second data table work if you create it from scratch rather than copying it?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Oct 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No, tried making it from scratch, not working either.

Tags for this Thread

Posting Permissions

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