'%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 Excel 365 Not Displaying Currency Data and Formula Errors
Question details
The user needs to restore the display of currency data in Excel 365 after functions abruptly stopped working without any manual changes to the worksheet.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Using built-in Excel formulas or functions to display currency data, which have suddenly stopped yielding results or are returning errors.
- Observed behavior
- Functions that previously displayed currency data have stopped working, potentially displaying a #NAME? error, even though the workbook itself was not modified.
Before beginning the troubleshooting process, verify if the currency display issue happens in a single specific workbook or across all your Excel files.
Repair Microsoft 365 Installation
Use the built-in Windows repair tool to fix corrupted Microsoft 365 application files that may be preventing functions from executing correctly.
Office installation problems or corrupted update files can cause unexpected behavior in Excel, such as functions suddenly failing to calculate. Running a Quick Repair or Online Repair often resolves these background application issues without affecting your personal data.
Click the Start button, type 'Settings', and press Enter to open the Windows Settings menu.
Click on 'Apps' from the left sidebar, then select 'Installed apps' or 'Apps & features'.
Scroll down to find your Microsoft 365 installation. Click the three dots (or right-click) next to it and select 'Modify'.
Choose 'Quick Repair' and click 'Repair'. If the issue persists after completion, repeat the process and select 'Online Repair' for a more comprehensive fix.
Correct Formula Spelling and #NAME? Errors
Check your worksheet for #NAME? errors, which indicate that Excel cannot recognize a function name or referenced formula.
Test the Workbook on Another Device
Determine whether the issue stems from workbook corruption or a local device problem by opening the file elsewhere.
Use WPS Office to Avoid Frequent Application Repairs
If Microsoft 365 frequently encounters installation issues or formula calculation bugs, WPS Office provides a lightweight, highly compatible alternative. You can easily view, edit, and manage your financial spreadsheets with familiar currency formulas and functions without the heavy system overhead.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install and Launch: Follow the quick installation prompts, then launch WPS Spreadsheets.
- 3. Open Your Workbook: Drag and drop your problematic Excel file into WPS Spreadsheets to securely view and calculate your currency data.
Frequently Asked Questions
Why does Excel show a #NAME? error for my currency formula?
A #NAME? error typically occurs if a function name is misspelled, if a required add-in for currency conversion is disabled, or if the formula references a named range that does not exist or was deleted.
Can a corrupted workbook cause currency data to disappear?
Yes, localized file corruption can break formula calculations. Testing the file on another device or uploading it to a web-based spreadsheet editor can help determine if the file itself is the source of the issue.
Will repairing Microsoft 365 delete my Excel files?
No. Running the Quick Repair or Online Repair from your Windows Settings menu only fixes the core application files and registry entries. It will not delete, move, or alter any of your personal spreadsheets.
