I have an Excel spreadsheet that was created using Office 2016 and the sheet that I created has formulas that reference blank cells. This sheet, which can be downloaded here, is set to automatically calculate in the TOTAL COST column (column I) and a TOTAL SUM of all TOTAL COSTS in cell I54. When I created this sheet on my computer, it worked flawlessly; however, when I email it or upload it to our website for potential vendors to download and fill, it does not automatically calculate in any of the locations. My questions are:
- Why does it work on my desktop and not on other people's systems? and
- How do I correct this?
Thanks for the help!