'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix the #NAME? Error with Excel VBA User-Defined Functions on Mac
Question details
The user needs to resolve a #NAME? error that appears when calculating VBA user-defined functions in Excel for Mac.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Running a macro-enabled workbook containing custom VBA user-defined functions on Mac Excel version 16.68, particularly when multiple copies of the workbook are open simultaneously.
- Observed behavior
- Excel formulas relying on VBA user-defined functions fail to calculate and unexpectedly display a #NAME? error.
Verify your current version of Excel for Mac by clicking 'Excel' in the top Apple menu bar and selecting 'About Microsoft Excel'. Also, verify that macros are fully enabled in your workbook settings.
Downgrade Excel for Mac to Version 16.67
Rolling back to the previous stable version resolves the #NAME? error caused by the specific bug in Excel for Mac version 16.68.
The #NAME? error with user-defined functions is a known issue isolated to Microsoft Excel for Mac version 16.68. Since the problem does not occur on Windows or earlier Mac versions, the most reliable temporary workaround is to revert to version 16.67 until an official patch is released.
Open Finder, navigate to your Applications folder, locate Microsoft Excel, right-click the application icon, and select 'Move to Trash'.
Open your web browser, navigate to the official Microsoft Office for Mac update history page, and download the standalone installer package for Excel version 16.67.
Run the downloaded installer package and follow the on-screen prompts to complete the installation of the older version.
Launch Excel, open your macro-enabled workbook, and check the formula cells to confirm that the #NAME? error has been resolved and values calculate correctly.
Try WPS Office as a Stable Alternative to Microsoft Office
If version-specific bugs in Microsoft Excel continuously disrupt your workflow, consider switching to WPS Office. It provides a highly compatible and robust environment for your spreadsheet processing needs without the frequent update-related compatibility issues.
- 1. Download WPS Office: Visit the official WPS Office website and download the appropriate installer for your Mac or PC.
- 2. Install the application: Run the setup file and follow the standard installation instructions to install the suite on your computer.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Microsoft Excel workbooks to continue your work.
Frequently Asked Questions
Why do my VBA user-defined functions return a #NAME? error?
The #NAME? error typically occurs when Excel cannot recognize the function name referenced in a formula. This happens if macro security settings disable the code, the function name is misspelled, the VBA module is missing, or due to underlying software bugs like the one found in Mac Excel version 16.68.
Can I fix this issue without rolling back my Excel version?
If you are on Mac Excel version 16.68, downgrading to 16.67 is currently the only confirmed workaround for this specific bug. Alternatively, you can wait for a subsequent update from Microsoft (version 16.69 or later) that patches the issue natively.
How do I report a software bug in Excel for Mac?
You can report bugs directly to Microsoft's development team by launching Excel, clicking the 'Help' option in the top Apple menu bar, and selecting 'Give Feedback'. Providing detailed steps and mentioning your exact system version will assist their investigation.
