+ Reply to Thread
Results 1 to 4 of 4

Linked formulas - Updating

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    Oklahoma
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    2

    Question Linked formulas - Updating

    For some reason formulas are not updating, even after refreshing and checking the links and verifying they are accurate. To update the formulas requires going to the formula bar, to the end of the formula and "enter". Even when formulas are copied using the fill handle, they maintain the original cell's data. There are NO absolutes in the formula and it is NOT an array formula. Examples: =C123 (linked to cell on same worksheet) ; =Staff_Hours!E122 (linked to cell on another sheet in workbook); also have formulas for links to other workbooks that are requiring the same attention. Any suggestions to fix this problem are appreciated. Thanks!

  2. #2
    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
    52,917

    Re: Linked formulas - Updating

    Hi and welcome to the forum

    It sounds to me like you have calcs set to manual?

    onthe ribbon, select FORMULA, CALCULATION, calculation options - select automatic
    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

  3. #3
    Registered User
    Join Date
    02-28-2013
    Location
    Oklahoma
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    2

    Thumbs up Re: Linked formulas - Updating

    Thank you - it worked! I had never encountered this problem before.
    So I did not realize there was a manual update feature.
    Thanks again for taking the time to respond and make my MONDAY so much better!

  4. #4
    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
    52,917

    Re: Linked formulas - Updating

    Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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