Excel cells don t calculate until I double-click them

0 votes
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?
Nov 7 in Others by Kithuzzz
• 20,660 points
27 views

1 answer to this question.

0 votes
Select all, find-replace = with =, and excel will see the contents as a formula.
answered Nov 7 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
242 views
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 11, 2018 in Talend by code.reaper12
• 3,500 points
1,073 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 3, 2018 in Talend by code.reaper12
• 3,500 points
2,714 views
+1 vote
1 answer
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer

How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
33 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP