A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel’s Stocks data type depends on an online financial-data feed. If XBOM:544847 is not being recognized, the most likely causes supported here are:
- The symbol is not currently covered in the Stocks data feed. Newly listed or unsupported securities may not appear immediately, and there is no separate customer process to manually add a ticker.
- The Stocks data type is temporarily having a service issue. Similar reports mention errors such as refresh failures or temporary server/service problems.
- The feature is unavailable because of account, sign-in, region, or privacy settings. Excel can return
#BLOCKED!when a required resource cannot be accessed.
Try this in order:
- In Excel, enter the company’s full legal name instead of only
XBOM:544847. - Select the cell, then go to Data > Stocks.
- If a question mark icon appears, open the Data Selector and search by company name and exchange to see whether Excel offers the correct listing.
- If it still does not appear, use Give feedback in the Data Selector, or Help/File > Feedback in Excel, and include the ticker, full company name, exchange, and listing date.
- Make sure Excel is signed in with a supported account, because Stocks is available to Microsoft 365 accounts or free Microsoft accounts.
- If Excel shows
#BLOCKED!, check:- File > Options > Trust Center > Trust Center Settings
- Under Security settings for linked data types, select Prompt user about linked data types or Enable all linked data types (not recommended)
- If the issue is only happening now and other stock symbols also fail to refresh, it may be a temporary service problem. In that case, try Excel for the web and report it through Feedback.
Excel’s stock and company data is provided by LSEG Data & Analytics.