1

Had Office, it uninstalled and I cant re install the disc as I am out of town. Computer repair installed LibreOffice. I am able to open and read my existing documents however the Excel spreadsheet will not calculate. In simplest terms, How do I fix? Please, can anyone help me with this Thanks

0

Please check if Data --> Calculate --> Autocalculate is enabled on your spreadsheet.

(This is the menu item under Libreoffice 5.2, it might differ slightly on other versions)

If the above is checked, don't forget to check under options --> Libreoffice Calc --> Formula --> Recalculation on File Load.

  • Checked this, it is enabled, still won't calculate. Any other suggestions? Thank you for your input – Lindalu711 Sep 18 '16 at 17:02
  • @Lindalu711 I know its been a while, but I think your problem was the second part of my answer. – Bruni Sep 20 '17 at 14:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.