Im using Excel 2007 or above. Should I save Hoadley applications as Excel 2007/2010 files?
Definitly not! Never change the file format of any spreadsheet downloaded from this web site. The Historic Volatility Calculator, Implied Volatility Calculator, the Portfolio Optimizer, the Options Strategy Evaluation Tool (OSET), etc are all Excel 97-2003 Workbooks (XLS). With this format these Excel applications will run under all versions of Excel from Excel 2002 including Excel 2010. If you use “save as” to change the file type to the newer Excel 2007/2010 format nothing will work correctly under any version of Excel. There is no reason whatsoever to change the file format and contrary to what many people think, simply saving a spreadsheet in the new Excel format will usually result in errors and slowness in loading for all but the simplest of spreadsheets. Of course any spreadsheet you create yourself and which uses functions from the Finance add-in for Excel can be saved in any format, including the new Excel formats. It is just the file format for applications downloaded from th
