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 using a plug-in.

import calculations in excel

These functions continue to be supported and are now available even directly. But Excel first looks for the plug-in and therefore displays an error message when it can’t find it. Correcting many cells with the same error is really cumbersome. However, you can make Excel reinsert all functions with a simple trick. To do this,

  • Select the ‘Home’ tab in the Ribbon bar, then right click ‘Find and Select’ and select ‘Replace’.
  • One character that appears in all functions is the ‘equal to’ sign.
  • Since you do not wish to change anything else, replace it with itself. Thus enter ‘=‘ in both the combination fields respectively and then click ‘Replace all’.
  • That way, Excel replaces all function definitions in the table and now displays correct results.
  • If only one cell needs to be corrected, select it for editing with the [F2] key, make your changes, and then press [Enter].
  • With that, Excel looks for the function again and displays the correct result.

Comments

Leave a Reply