How to use Macro enabled workbooks from Excel 2003 in Excel 2007
Posted on 2010-08-15
A client is using Microsoft Office 2003 and has a macro-enabled workbook, they want to share this with a user on Office 2007.
When the user on '07 runs a macro button "new day" that populates a new page with formulas, none of the formulas are being copied as they normall should in '03.
How can I make the spreadsheet compatible with more recent versions of Office?