+ Reply to Thread
Results 1 to 6 of 6

Spreadsheet not re-calculating values automatically

  1. #1
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Spreadsheet not re-calculating values automatically

    I have attached a spreadsheet with a large table on it, who's values will not automatically re-calculate with each cell change, save etc.. (I have Workbook Calculations set to Automatic)

    I never experienced this problem before. Can anyone help?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Spreadsheet not re-calculating values automatically

    No solution but you have circular references on this file.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Re: Spreadsheet not re-calculating values automatically

    How do I go about finding where the circular references are? Could this be causing the problem?

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: Spreadsheet not re-calculating values automatically

    https://www.google.co.uk/#q=excel+lo...ular+reference

    Not sure if it will resolve because of that.

  5. #5
    Forum Contributor
    Join Date
    12-02-2014
    Location
    England
    MS-Off Ver
    2010 | 2016
    Posts
    167

    Re: Spreadsheet not re-calculating values automatically

    Turn your calculations back to automatic.

    Google calculation in Excel and you should find a guide.

    Circular references should be viewable by going Formulas -> Error Checking -> Circular References

  6. #6
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Re: Spreadsheet not re-calculating values automatically

    My calculations are set to automatic.

    "(I have Workbook Calculations set to Automatic)"

+ 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] Lookup values in one spreadsheet and automatically input into another spreadsheet
    By prefcomm in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-08-2013, 05:26 PM
  2. Spreadsheet Automatically Adds an Entry to Separate Spreadsheet in Workbook
    By larajolly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2012, 06:02 PM
  3. Replies: 3
    Last Post: 01-09-2012, 09:04 PM
  4. Replies: 0
    Last Post: 11-29-2009, 08:41 AM
  5. [SOLVED] Automatically Copy Specific Values to a Different Spreadsheet?
    By Matt in forum Excel General
    Replies: 4
    Last Post: 05-17-2006, 06:45 PM
  6. Spreadsheet not calculating
    By Gazzr in forum Excel General
    Replies: 3
    Last Post: 03-09-2006, 09:10 PM
  7. Not Automatically Calculating Formulas
    By Archie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2006, 08:45 AM
  8. Replies: 1
    Last Post: 02-08-2005, 06:06 AM

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