+ Reply to Thread
Results 1 to 4 of 4

What's wrong with this Excel file? Formulas not working.

  1. 01-26-2016, 12:50 PM #1
    AlphaBob
    AlphaBob is offline
    Registered User
    Join Date
    12-01-2008
    Location
    USA
    Posts
    13

    What's wrong with this Excel file? Formulas not working.

    I can not figure out what is wrong here. This is a simple formula (=B2-B3) normally I can click on the little box in the lower right hand corner of the highlighted cell and it repeats the formula for the entire column.

    But for some reason it seems to repeat the formula but instead of calculating a new value for every cell it repeated the value of the first cell.

    If I go back and enter the formula manually in every cell it calculates it properly.

    What is wrong with this file and why is Excel not calculating the formulas corectly?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-26-2016, 12:52 PM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: What's wrong with this Excel file? Formulas not working.

    On the Formulas Tab, Set Calculation Options to Automatic.
    Reply With QuoteRegister To Reply
  3. 01-26-2016, 01:02 PM #3
    AlphaBob
    AlphaBob is offline
    Registered User
    Join Date
    12-01-2008
    Location
    USA
    Posts
    13

    Re: What's wrong with this Excel file? Formulas not working.

    That was it, Thanks!

    I don't understand how that got changed to manual. I know I did not change it, I did not even know you could do that.
    Reply With QuoteRegister To Reply
  4. 01-26-2016, 01:03 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: What's wrong with this Excel file? Formulas not working.

    You may have opened a file that had been set that way by someone else
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Editing A .csv file with excel... Where did I go wrong?
    By MrSalvage in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 11-30-2023, 11:15 AM
  2. What is wrong with my Excel File?
    By RHaybusa in forum Excel General
    Replies: 2
    Last Post: 01-21-2016, 04:07 AM
  3. Excel 2003 file formulas not working on Win 8 Off 2013 on certain laptop but work on other
    By huyserhw in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2015, 08:07 AM
  4. Excel don't accept formulas between two workbooks - whats wrong?
    By SPK_boy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2014, 03:52 PM
  5. Converted Address Label PDF File to Text File and need to get it working in Excel
    By Samuel79 in forum Excel General
    Replies: 1
    Last Post: 02-09-2013, 02:15 AM
  6. why do formulas stop working in an excel file?
    By George in forum Excel General
    Replies: 5
    Last Post: 07-31-2006, 03:13 PM
  7. Double clicking an Excel file is not working. What's wrong?
    By VU2IM in forum Excel General
    Replies: 3
    Last Post: 06-08-2006, 03:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1