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

​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  Read More

​