Fix Missing 52-Week Low Stock Data in Excel
Question details
Find out why 52-week low and other Refinitiv stock data fields are unavailable for some Danish companies in Excel.

- Product
- Microsoft Excel and Refinitiv stock data
- Device & OS
- not provided
- Scenario
- The user is retrieving stock data for Danish companies, including Carlsberg and Novo Nordisk, in Excel.
- Observed behavior
- Some fields are unavailable for Carlsberg and multiple other Danish companies, while they remain available for Novo Nordisk. The issue appears to be worsening.
Identify whether the workbook uses Excel's Stocks data type or a Refinitiv add-in, and note the affected ticker, exchange, and missing field names. Keep an unaffected security such as Novo Nordisk available for comparison.
Check the Stock Listing and Refresh Excel Data
Use this method to rule out an incorrect security match or stale linked data.
Select the affected stock cell in Excel and open its data card, if available. Confirm that the company name, ticker, exchange, and listing match the security you need.
If Excel matched the wrong security, right-click the stock cell and choose Data Type > Change, then select the correct listing in the Data Selector.
Choose Data > Refresh All in Excel, or use the refresh command in your Refinitiv add-in if the workbook gets its data through that add-in. Check the 52-week low field again.
Check the same field for an unaffected company such as Novo Nordisk, using the same data source and workbook method. This helps establish whether the problem affects specific securities.

Verify Refinitiv Coverage and Account Permissions
Use this method if the correct listing still has missing fields after a refresh.
Work With Stock Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Excel format compatibility for an easier move between office suites. It does not fix missing Refinitiv fields or provider permissions.

Frequently Asked Questions
Why is the 52-week low available for one stock but not another?
Availability can differ by security, exchange, listing, field coverage, or account permissions. Compare the affected listing and field in Refinitiv Workspace or another supported interface.
How do I refresh stock data in Excel?
Choose Data > Refresh All. If the workbook uses a Refinitiv add-in instead of Excel's Stocks data type, use the add-in's refresh command.
How can I correct an incorrectly matched stock in Excel?
For an Excel Stocks data type cell, right-click the cell and choose Data Type > Change. Select the intended company and exchange in the Data Selector.
Can WPS Office restore missing Refinitiv data?
No. WPS Office can open and edit Excel-format spreadsheets, but it cannot restore fields missing from Refinitiv or change your provider permissions. Check linked-data and add-in compatibility before moving a workbook that depends on them.




