Forum Discussion
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.
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.