+ Reply to Thread
Results 1 to 4 of 4

Formulas In Place But Not Updating

  1. #1
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    72

    Formulas In Place But Not Updating

    Is there some security thing in Excel that is so 'rigid' that formulas from a spreadsheet (that's been downloaded from an email) will not update, even though the option to enable macros has been selected. My wife has a file that is a Stock Sheet with a straightforward arrangement of: quantities (e.g F8), prices per unit (G8), and a formula to multiply one by the other (F8*G8). The formula is visible in the formula bar. Some previous quantities are showing, and the stock value is shown, and the result of the multiplication is shown. Now if we change the quantity we expect the formula to update, but it doesn't. There is protection and the formula cells are locked, but editing is allowed (and there is no secret password for the protection), and, yet, the formulas stay showing the values that they had before the editing starts. I've used spreadsheets for many years, but never seen this. Can someone tell me what to do to make the various formulas here update as they should normally do? Thanks.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formulas In Place But Not Updating

    Check if Calculation is set to Manual....It should probably be set to Automatic.
    In later versions of Excel:
    Formulas.Calculation_Options.Automatic

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    72

    Re: Formulas In Place But Not Updating

    I think it will, Ron, thanks. The file is fine on my laptop. On my wife's work laptop it has this problem. Soon as I get a chance I'll confirm whether that is the solution.

  4. #4
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    72

    Re: Formulas In Place But Not Updating

    Well, that was it, Ron, thanks again. Calculation Options had been set to Manual. Once altered to Automatic, everything behaved fine - formulas updated immediately on input . . . Thank you.
    Lotusman

+ 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. Locking formulas in place
    By Marklar in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-15-2015, 03:56 AM
  2. Adding 51 rows down to already in place formulas
    By amartino44 in forum Excel General
    Replies: 1
    Last Post: 08-19-2013, 06:14 PM
  3. Sorting is throwing my formulas out of place. Looking for solution.
    By AKM1 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-04-2013, 11:31 AM
  4. Macro to auto place formulas
    By Wskip49 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2011, 12:53 AM
  5. A for loop which will place formulas into cells going down a column
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-17-2010, 05:47 PM
  6. Using Labels in Place of Cell Ref in Formulas
    By sudburydave in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 10-21-2007, 05:40 PM
  7. Help with keeping formulas in place!
    By tapuza in forum Excel General
    Replies: 3
    Last Post: 12-23-2005, 03:25 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