Forum Discussion

mdmacaraeg's avatar
mdmacaraeg
Copper Contributor
Mar 29, 2017

Excel file which is saved as Macro enabled data's are unable to see in 2013 version

When I open an Excel file which is saved as Macro enabled, some of the datas are unable to see. It reflects as #name.  what can be done to see the datas. I'm using Excel2013 64bit.

 

excel
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Apr 07, 2017
    Hi Michael, this error could occur if the file contains formulas or functions from a newer Excel version, which are not implemented in Excel 2013. When you click on a cell with the #name error, you might see a formula starting with "=xlfn." followed by the function name that is not working. If this is the case, the only way out is to replace these formulas in Excel 2016 with ones that are available in Excel 2013.

Resources