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?