Calculating two sheets at the same time?
Should one stay away from calculating two sheets at the same time?
I was working on one sheet with another one calculating in the background. An error (something about exchange over domain not being possible) occured when recalculating the active sheet. The background sheet stalled with the same error.
I had seven sheets opened at that time. I closed them all to see if a restart would reactivate the two sheets with errors, but all seven failed when I tried to reopen them: five with corruped file messages and two with invalid XML file error.
Thanks to a recent back up, this was only a half day of work loss, but still a rather shocking experience!
Autosave was no help either.
