Hi folks,

I recently emailed a file to a client, and when they opened it on their end, the Excel Options Settings had changed such that the formulas across the whole workbook were not auto-calculating. A quick click back to Automatic form Manual under the 'Formula' section solved the problem, but what I don't understand is how the setting could have changed by itself. The client said they didn't make any changes.

The file was created with Excel 2010 and opened on Excel 2010. Client is using Windows 7, as am I. I also opened a new workbook on their computer by remote access and tested some formulae and they worked fine.

Any ideas on how this might happen?

Thanks for your time.

Owen