This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Just purchased a new MacBook Air w/ macOS Sequoia. Everything works well except for Excel. It shows errors in formulas that normally work on other Macs and PC's.
Whatever I change in the model, it starts showing #Name? throughout the Workbook. I also realized that some formulas that normally work on other computers have an "add-on" - "_xlfn." in front of the formula, which means there's an error. However, that does not exist in the same cell on a different computer.
How can I fix this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Which version of Office do you have on the Mac? the _xlfn prefix means that the function is unavailable in the version of Excel. If you have just installed Office, you may want to update it and then reboot just to see if that cures it.
You're welcome - glad we could help! :)
Always nice when it's a simple resolution too.
Rory, just wanted to report back. Your suggestion fixed the issue fully. I can't thank you enough and I am so embarrassed I didn't know that. Enjoy the Weekend, you saved my day.
Rory, first I would like to thank you so much for replying as I was very desperate. Let me try updating and will report back. Thanks again, Jovan