Forum Discussion
#NAME? error for ANCHORARRAY function
Hello,
I have just been sent a spreadsheet, with #NAME? errors in some of the spreadsheets. These all have ANCHORARRAY functions included.
When opened in Google Sheets it says Unknown Function and when opened in Microsoft Excel it says there is a name error.
Would be helpful to know what to do to fix this error.
Many thanks,
Katie
The workbook has probably been created in SPREAD.net.
In Excel, you can try changing - for example - ANCHORARRAY(B2) to B2#
