+ Reply to Thread
Results 1 to 2 of 2

Has anyone else had issues with formulas not calculating in Excel 2016?

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Has anyone else had issues with formulas not calculating in Excel 2016?

    I have recently upgraded? to MS Excel Professional Plus 2016.

    I have a sheet that is not calculating until I go into the cell, click in the formula bar and then hit enter.

    I have my calculation settings set to automatic. Even hitting F9 to force a calculation is not updating the results.

    Anyone else encountered this issue? I thought it may possibly be a corruption thing and I might have to transpose everything into a new workbook, but hoping not.
    Handy things to keep in mind:

    Click *, if my suggestion has helped you
    If your problem is solved, then please mark the thread as SOLVED

    Sharing is Caring .... spread the knowledge

  2. #2
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Re: Has anyone else had issues with formulas not calculating in Excel 2016?

    I think I have identified it.

    I have circular references in my workbook via an IF function ... I had to enable iterative calculation for it to calculate as it was retaining the last successful calc value.

+ 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. Replies: 7
    Last Post: 07-25-2017, 08:38 AM
  2. Problems / small issues in Excel 2016
    By MathiasV in forum Excel General
    Replies: 3
    Last Post: 09-02-2016, 08:03 AM
  3. Excel 2016 Pivot Issues
    By jsds13 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-29-2016, 03:35 PM
  4. [SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2016, 12:14 PM
  5. [SOLVED] Issues with code sent from 2010 to 2016
    By dwr2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2016, 03:57 PM
  6. Excel 2016 issues: Adding sheets and find replace.
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2016, 07:25 AM
  7. Replies: 2
    Last Post: 02-21-2016, 03:33 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