This MSKB article gives more information about the behaviour of this
option in 2000 to 2003:

http://support.microsoft.com/kb/213836/en-us

and this one is for 2007:

http://support.microsoft.com/kb/930479/en-us

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup