Skip to Content
Functions and formulasCompatibilityFunction availability
All platforms

Check whether a function works on your add-in

Confirm platform availability, use the right formula name, and test a workbook before you move it between add-ins.

The Windows desktop and Microsoft 365 add-ins share many functions, but their formula syntax and some features differ. Check one function before you change a whole workbook.

Identify the add-in that owns the formula

Look at the beginning of the formula:

  • =Last("MSFT") uses the Windows desktop add-in.
  • =mxls.Last("MSFT") uses the Microsoft 365 add-in on Mac, Windows, or Excel for the web.

Windows desktop Excel can have both add-ins installed. In that case, the mxls. namespace tells you that the Microsoft 365 add-in owns the formula. It doesn't tell you which operating system the workbook is using.

Read Compare formula syntax by platform if you aren't sure which add-in is active.

Check the formula reference

  1. Open the MarketXLS formula reference.
  2. Search for the function name without = or mxls..
  3. Use the platform filter:
    • Excel Desktop means the Windows desktop add-in.
    • Excel Online means the Microsoft 365 add-in used on Mac, Windows, or the web.
  4. Open the formula page.
  5. Use its platform switch to view and copy the correct syntax.

The online formula isn't always the Windows name with mxls. added. Some functions have a different registered name in the Microsoft 365 add-in, and the formula page's platform switch can show that mapping.

Confirm the function in Excel

Excel autocomplete is the final check for the add-in version that is currently loaded:

  1. Open a blank workbook.
  2. On Windows desktop, type = followed by the function name.
  3. On Microsoft 365, type =mxls. followed by part of the function name.
  4. Select the function from Excel's suggestions.
  5. Enter a simple test with a common symbol such as MSFT.
Autocomplete confirms which MarketXLS functions the currently loaded add-in has registered.

If autocomplete doesn't show the function, adding or removing mxls. repeatedly won't make an unavailable function appear. Confirm that the intended add-in is loaded, then check the platform label and the current function name.

Move a workbook between add-ins

Don't run a workbook-wide text replacement until you test its function families.

  1. Save a copy of the workbook.
  2. List the distinct MarketXLS function names that it uses.
  3. Check each name in the formula reference.
  4. Test one example from each family on the destination add-in.
  5. Replace formulas only after you confirm the destination name and parameters.
  6. Refresh a small range and compare the results.

A template can also depend on a Windows ribbon command, COM automation, or a Microsoft 365 dynamic-array function. Formula compatibility alone doesn't guarantee that the entire workflow is portable.

Fix #NAME?

#NAME? means that Excel doesn't recognize a name in the formula. Common causes include:

  • The required MarketXLS add-in isn't loaded.
  • A Microsoft 365 formula is missing mxls..
  • A Windows formula was copied into the Microsoft 365 add-in without checking its registered name.
  • The function isn't available on that add-in.
  • The workbook contains an old or misspelled function name.

Follow Fix a #NAME? error for the shortest diagnostic steps.

Report an incorrect platform label

If the formula reference says that a function is unavailable but Excel autocomplete shows it, or the page shows a name that Excel doesn't register, contact MarketXLS support. Include:

  • The formula-reference link
  • The exact name shown by Excel autocomplete
  • Windows desktop or Microsoft 365
  • Your MarketXLS add-in version
  • A screenshot of the autocomplete result without private workbook data

This distinction helps MarketXLS correct the catalog entry instead of treating the report as an add-in failure.

Platform differencesQuoteMedia functions
© 2026 MarketXLS. Financial data documentation for Excel.