That probably turned the cell into a text format cell, even though technically the cell was still a number and listed as one under the formats.I stripped the quotes and the cells calculated as normal.
Your answer is really a somewhat random reference to a different problem you had. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
There are two ways to program a spreadsheet to update automatically: every time the workbook is opened and at regular intervals that you determine. Make sure you are on the "Usage" tab of the "Connection Properties" dialog box.
Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.
She has also contributed to The Dollar Stretcher, Life Tips and Childcare Magazine.
After you create a chart, you might have to change its source data on the worksheet.
I am hoping to retire from my full time job through writing so I can buy a cabin in the South Carolina mountains and become a career author.
However, for some reason, the value calculated by the formula does not update automatically. We already had the calculation options set to automatic and didn't know why values weren't updating.
To incorporate these changes in the chart, Microsoft Office Excel provides various ways to update a chart.