Bloomberg spreadsheet not updating

When I change the input of a formula, the output is not automatically updated. How do I get Excel to update formulas automatically again?

If it is, this sounds like one of the most annoying viruses in the world!

No, most likely you simply have calculations set to Manual, or something else similar such as an add-in, macro or extension e.t.c.

bloomberg spreadsheet not updating-46

To check for the easiest one, go to I think this may be a bug.

I've had the same issue since we recently "upgraded" to Office 2013.

I have formulas linking to other tabs in the same workbook.

Some of them are not even formulas - they just "=" the number from the other tab. I've found that if you click in the formula bar when in the source cell, and hit enter, it refreshes the cell which is linked to it.

I had a case of this just now on Excel 2010: a particular spreadsheet that would not auto-recalculate.

I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.

Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.

To do this on a grand scale, I do a Find "=" & Replace with "=" for the whole workbook.

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.

Tags: , ,