Fix a #NAME? error | MarketXLS documentation

Excel shows #NAME? when it doesn't recognize part of a formula. With a MarketXLS formula, the common causes are the wrong platform syntax, an add-in that hasn't loaded, or a misspelled function name.

Before you rename several formulas, check whether the function works on your add-in. Some Microsoft 365 functions use a different registered name, not only an mxls. prefix.

Check the platform syntax

Use the syntax for your add-in:

Add-in	Test formula
Windows desktop	`=Last("MSFT")`
Mac or Excel for the web	`=mxls.Last("MSFT")`

If you moved the workbook between platforms, read Compare formula syntax by platform.

Screenshot needed · WIN-FORMULA-01

Capture the Windows Last formula and its returned value.

/images/docs/windows/first-formula.webp

Use the unprefixed function name with the Windows desktop add-in.

Screenshot needed · M365-FORMULA-01

Capture the Microsoft 365 mxls.Last formula and its returned value.

/images/docs/microsoft-365/first-formula.webp

Use the mxls. namespace with the Microsoft 365 add-in.

Check the add-in

Windows desktop

Confirm that the MarketXLS ribbon tab is visible.
If it isn't visible, restore the missing ribbon.
Close Excel, open it again, and test the formula in a blank workbook.

Mac or Excel for the web

Open MarketXLS (Web) from the ribbon.
Confirm that the task pane loads.
Sign in if the task pane asks you to do so.
Test =mxls.Last("MSFT") in a blank workbook.

Screenshot needed · WIN-ADDINS-01

Capture the COM Add-ins dialog with MarketXLS enabled.

/images/docs/windows/com-addins-enabled.webp

On Windows, confirm that Excel loaded the MarketXLS COM add-in before you rename formulas.

Check the function name

Search the formula reference. Copy the function name and confirm that it is available on your platform.

If the function works in a blank workbook but not in the original workbook, save a copy of the original file and check for old formula names or links to another workbook.