Forum Discussion
mellowdy
Sep 15, 2022Copper Contributor
help my downloaded excel only shows #name?
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.
HansVogelaar
Sep 15, 2022MVP
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.
- mellowdySep 16, 2022Copper Contributor
how do I know if my excel is office 2021? or older??
- Tanya DentonSep 16, 2022Iron Contributor
- mellowdySep 16, 2022Copper Contributorthanks it is 2016... so I have to buy 2021 or 365?? or is there anyway I see the excel without any issue?