+ Reply to Thread
Results 1 to 3 of 3

Calculations don't update until saving workbook

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Calculations don't update until saving workbook

    Hello all,

    Not sure why today my budget workbook won't update my calculations until I save the workbook. Does anyone know why this is happening and how to fix.

    Thank you very much for helping me in advance,
    Joe

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Calculations don't update until saving workbook

    Hi Lewis and welcome to the forum,

    On the formulas tab you have Calculations Options set to Manual. Change them to Automatic and I think your problem is solved.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Calculations don't update until saving workbook

    Thank you so much! I thought I had to start over making this thing.

+ 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. Changing reference, saving original calculations
    By jorjacman in forum Excel General
    Replies: 2
    Last Post: 01-24-2014, 04:40 PM
  2. Changing reference, saving original calculations
    By jorjacman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2014, 02:54 PM
  3. Automatically Update Table Calculations
    By Cardan in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2014, 03:16 AM
  4. saving to a specific file as workbook is update
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-09-2013, 06:22 AM
  5. Renaming Active.Workbook and saving it without saving Macro
    By Djwill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-04-2012, 03:09 AM
  6. Allow saving upon closing a workbook even when saving is disabled.
    By Tino XXL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2011, 09:09 AM
  7. update:Saving a worksheet
    By whitesidehasdon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2007, 05:13 PM
  8. update cell without saving
    By philvis in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 07:13 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