Hi. I'm new here.

Anyone got any experience of Excel 2003 functions not working in Excel 2007?

I'm referring to VB functions, which have worked fine for years in XL2003. In XL2007 endless errors appear in the worksheets. Saving the workbook as .xlsm in XL2007 makes no difference.

The functions work fine in the .xls workbook providing the PC's had Excel 2003 installed on it in the past, and an upgrade to Excel 2007. But if the PCs had a fresh Windows/Excel 2007 build on it, the functions I'm using give errors. I'm not keen on a workaround/rewrite, as the file's 71mb, and has many worksheets and formulae - all of which would need double-checking. Microsoft don't appear to have anything on their site to help.

Thanks in anticipation.