+ Reply to Thread
Results 1 to 7 of 7

Excel data table yielding incorrect values from entering them manually

  1. #1
    Registered User
    Join Date
    03-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    4

    Excel data table yielding incorrect values from entering them manually

    Please see attached 'sensitivity' tab; as you can see all my inputs I'm trying to sensitize are in cells M1,M2,M3 and M4. I'm trying to see how changes to these values affect the return in cell C2.

    When I manually make adjustments to the input in M3, for example, it yields a corresponding adjustment to C2. However, when I sensitize them in a data table on the right, the values are incorrect.

    I suspect it has to do with a circular reference or something, but have no idea why this is going on.

    please help!

    Thanks

    For some reason I can't attach; file is uploaded at: ufile (dot) io/uf8wa
    Attached Files Attached Files
    Last edited by AliGW; 03-04-2018 at 04:23 AM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: URGENT - Excel data table yielding incorrect values from entering them manually



    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Registered User
    Join Date
    03-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    4

    Re: URGENT - Excel data table yielding incorrect values from entering them manually

    It keeps saying 'upload of file failed'...this is insane!

  4. #4
    Registered User
    Join Date
    03-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    4

    Re: URGENT - Excel data table yielding incorrect values from entering them manually

    Is it too big? 2.2 MB

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: URGENT - Excel data table yielding incorrect values from entering them manually

    save as xlsb then try to attach again

    but we need representative sample not whole data

  6. #6
    Registered User
    Join Date
    03-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    4

    Re: URGENT - Excel data table yielding incorrect values from entering them manually

    Great - it's uploaded. You should see all the inputs on the 'Sensitivity' tab - please help me out! I explained the issue in detail, let me know if it's not clear. I am so thankful for this.

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: URGENT - Excel data table yielding incorrect values from entering them manually

    You've circular reference on Project Budget C51 and E51
    try to check it why
    or go to Options - Formulas and enable Iterative Calculations then check if it will work for you

    cr.jpg

    try to use Trace Precedents and Dependents

    edit:
    btw. all 4 external files are unaccessible so you need to chack them also

    here is Workbook Analysis with errors, hidden cells, unused cells etc etc....
    Attached Files Attached Files
    Last edited by sandy666; 03-03-2018 at 10:23 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Solution to Manually entering and reentering table information
    By tburgerjr in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-14-2016, 06:07 PM
  2. Incorrect excel data table results
    By pisco in forum Excel General
    Replies: 0
    Last Post: 08-21-2015, 04:38 AM
  3. Replies: 10
    Last Post: 02-02-2015, 01:22 PM
  4. [SOLVED] vlookup - entering new data manually into data validation cell
    By rdd2 in forum Excel General
    Replies: 3
    Last Post: 03-12-2014, 03:09 PM
  5. Replies: 5
    Last Post: 02-09-2014, 11:04 PM
  6. Urgent help required: lock the data in a cell after entering the value.
    By vikrantrai0102 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2014, 06:30 AM
  7. Replies: 3
    Last Post: 03-24-2012, 08:18 PM

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