help my downloaded excel only shows #name?

Copper Contributor

Hi, I downloaded the excel file, but it shows that #name?

I wish I could load my screen shot but they said I have no permission...? https://ibb.co/9GszNpY 

please help me how to fix this issue.

7 Replies

@mellowdy 

The workbook uses the FILTER function. This is only available in Excel in Microsoft 365 and Office 2021, and in Excel Online (the browser version), not in older versions.

how do I know if my excel is office 2021? or older??

thanks it is 2016... so I have to buy 2021 or 365?? or is there anyway I see the excel without any issue?

@mellowdy 

If you upload the file to Microsoft OneDrive, you can view it in Excel Online.

what about on google drive? does that work too?
wow you guys are great I mean onedrive works like you guys said...