#NAME? error for ANCHORARRAY function

[KatiePattinson]

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

[#2]

@KatiePattinson 

The workbook has probably been created in SPREAD.net.

In Excel, you can try changing - for example - ANCHORARRAY(B2) to B2#