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, 2022 in Others by Kithuzzz
• 38,010 points
643 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, 2022 by narikkadan
• 63,700 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, 2022 in Others by narikkadan
• 63,700 points
1,096 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

answered Apr 1, 2023 in Others by narikkadan
• 63,700 points
469 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, 2022 in Others by Edureka
• 13,670 points
1,766 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, 2022 in Others by Edureka
• 13,670 points
1,570 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,585 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
3,684 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, 2022 in Others by narikkadan
• 63,700 points
583 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, 2022 in Others by narikkadan
• 63,700 points
607 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