Forum Discussion

Nigel Knapp's avatar
Nigel Knapp
Copper Contributor
Apr 15, 2018

Build 1803 formulas not working

I make an Excel speadsheet using PHPExcel for a client that has never had any issues until Office 365 Excel Version 1803 came along.  The client downloads the spreadsheet from my website, opens it an...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 16, 2018

Hi Nigel,

 

Please check if automatic calculation is set in options

  • Nigel Knapp's avatar
    Nigel Knapp
    Copper Contributor
    Apr 16, 2018
    Thanks Sergei but that is what I meant by "I have checked that Calculate is set to automatic".
    • Mick Tindall's avatar
      Mick Tindall
      Copper Contributor
      Apr 16, 2018

      I'm having the same issue, PHPExcel created files, and that setting is correct.

       

      I've found that if i click into the cells with formulas, click in the box where the formula is at the top, and hit the enter key, it will then calculate.

       

      Also have found that the formulas will calculate after sorting.

       

      Really need to find a fix for this fast.

      • Nigel Knapp's avatar
        Nigel Knapp
        Copper Contributor
        Apr 16, 2018
        Hi Mick
        I found exactly the same thing. It is the same reason why ctr+shift+alt+f9 works. Programatically it sounds like the refresh calculation function is failing to run on load but works fine on change. I'm hoping an MVP sees this message and either provides a solution or reports it as a bug.