'%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 Changing Formulas to the @MS Function
Question details
Users experience an issue where Excel automatically drops portions of complex functions and replaces the formula structure with an unsupported @MS syntax when opening older workbooks.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a workbook created in Excel 2016 using Excel 2021.
- Observed behavior
- Excel drops the original functions (such as IF and HLOOKUP) along with their final arguments, and replaces the formula with an unexpected =@MS(...) format.
Create a backup copy of your original Excel 2016 workbook to ensure you do not lose the initial data and untouched formulas before attempting to repair the calculation chain.
Manually Restore and Verify the Original Formula
Replace the corrupted @MS formula with your original function and save the workbook to test its stability in the new Excel version.
Often, file conversion glitches or unsupported add-ins can disrupt how newer versions of Excel interpret legacy formulas. Re-entering the formula manually can force Excel to recalculate and recognize the correct functions.
Open your workbook in Excel 2021 and select the cell that displays the incorrect =@MS formula.
Click into the Formula Bar at the top of the screen and clear the broken formula entirely.
Type or paste your original formula back into the bar. For example: =IF(HLOOKUP(Data!A1,INDIRECT(PersonTable),4)="Married",4,3).
Press Enter to apply the formula, then save the workbook as a new file. Close and reopen the file to verify if the formula remains stable.
Identify Add-in Conflicts using Safe Mode
Check if an outdated or unsupported third-party add-in is modifying your formulas upon opening the file.
Use WPS Office to Prevent Version Compatibility Formula Errors
If you frequently encounter formula corruption or unexpected @MS syntax changes when moving files between older and newer versions of Microsoft Excel, WPS Office offers a highly compatible, stable, and free alternative.
- 1. Download WPS Office: Visit the official WPS website to download the free installer and complete the setup process.
- 2. Open WPS Spreadsheets: Launch the application and select Spreadsheets from the main home screen.
- 3. Import the Excel Workbook: Click Open and select your Excel 2016 file to edit your formulas without unexpected @MS conversions.
Frequently Asked Questions
What does the @MS function mean in Excel?
The @ symbol in Excel is generally used as the implicit intersection operator in newer dynamic array formulas. However, an unprompted =@MS(...) structure usually indicates a corrupted formula, an incompatible macro, or a broken add-in translation from an older Excel version.
Why did my IF and HLOOKUP formulas disappear during the Excel update?
When migrating from Excel 2016 to Excel 2021, file conversion glitches, document recovery artifacts, or unsupported third-party COM add-ins can disrupt the calculation chain. This causes Excel to drop recognized functions and replace them with a broken syntax.
How can I share the workbook for further inspection if the formula keeps changing?
If the formula continues to change after manually fixing it, it is recommended to upload the file to a secure cloud file-sharing service like OneDrive, Dropbox, or Google Drive, and provide the download link to support personnel to examine the workbook's behavior.
