Thread hijack since yours is fixed. I had Excel this week just simply
stop auto-calculating. I had to go into the options and check that I wanted to auto-calculate every time a value changed or was added/deleted. I accused my IT guys of messing around with the defaults - they blamed the Russians....