Im using Excel 2007. Should I save Hoadley applications as Excel 2007 files?
Definitly not! Never change the file format of any spreadsheet downloaded from this web site. The Historic Volatility Calculator, Implied Volatility Calculators, 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 2007. If you use “save as” to change the file type to the newer Excel 2007 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 2007 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 2007 formats. It is just the file format for applications downloaded from thi