Results 1 to 6 of 6

Error: One-Way Data Table / Sensitivity Table: Only correct value is current input!

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2016
    Location
    Chicago, USA
    MS-Off Ver
    2013
    Posts
    3

    Error: One-Way Data Table / Sensitivity Table: Only correct value is current input!

    I am an very advanced Excel user, and I have a problem with a one-way sensitivity table that nobody is able to sovle. Here is the problem:

    1 - Calculations are set to "Automatic" - - - yet I still need to hit F9 for the table to recalculate
    2 - The only part of the sensitvity table that is correct is the part for which the active scenario is currently set, so if scenario "1" is active, that is the only part that is correct in the sensitvity table (see attached)
    3 - Per number two above, the sensitvity table does not stay fixed, as it should, but changes depending on what the active scenario is
    4 - Not all rows of my sensitvity table are impacted by problem number two and three above, but only those related to a couple input formulas (highlighted in yellow with red text in attached)
    5 - The input variable is on the same page as the sensitvity table
    6 - I have Google'd the pants off this and have not found any solutions, nothing has worked so far
    7 - Last time I had this problem (which was awhile ago) I think there was a circular reference somwhere and that fixed the problem; however, I have done the error checking and there is no circular reference that Excel has found
    8 - "Enable iterative calculation" is checked

    Please sombody have mercy and tell me what is going.

    Best,

    IronGoat
    Attached Files Attached Files
    Last edited by IronGoat; 10-01-2016 at 07:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Table in separated Sensitivity sheet
    By ibrahimdaas in forum Excel General
    Replies: 6
    Last Post: 11-25-2015, 05:16 AM
  2. Data table for sensitivity matrix
    By brad-m in forum Excel General
    Replies: 10
    Last Post: 07-15-2015, 04:01 PM
  3. Replies: 2
    Last Post: 10-25-2013, 07:26 PM
  4. [SOLVED] Transfer current row of data (Table) to a new row in a second table on the same sheet
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 11:12 PM
  5. The correct way of referencing the data source for a pivot table... error
    By lgjmac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2013, 03:51 PM
  6. Sensitivity Table: 1 input, 2 outputs
    By Cheathering in forum Excel General
    Replies: 1
    Last Post: 09-14-2011, 11:26 AM
  7. Sensitivity Analysis-Data Table
    By koklok123 in forum Excel General
    Replies: 6
    Last Post: 03-19-2010, 11:29 AM

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