Import Calculations from old versions of Excel without a Problem

While upgrading to Excel 2007, you imported calculations from older Excel documents. However, the import wasn’t 100 percent successful and you get the error message ‘#NAME?’ in some cells. The problem occurs if you have used analysis functions such as ‘CONVERT’, ‘CALENDAR WEEK’ or ‘MROUND’ in the calculation, which you had to activate earlier as […]