Excel cells don t calculate until I double-click them

Question

A spreadsheet I have in Excel has three sum functions. The sheet is a template, thus everything but the few text descriptions in Column A is blank. I opened the worksheet using an ETL procedure (Talend Open Studio), enter some data, attach a few other sheets, and store this unique worksheet in a file share. The three cells containing the sum functions show as zero when I first open the worksheet in the file sharing, but when I double-click the cell, they calculate as expected.

Without my double-clicking the cells, I want them to display the calculation.

The Calculation option is set to Automatic, and the cells are formatted as General. What should I do?

Answer 1

Select all, find-replace = with =, and excel will see the contents as a formula.