Troubleshoot Excel Macro and #VALUE! Errors in WPS Office After Moving Computers
Question details
The user needs to resolve macro failures and #VALUE! formula errors that appear after moving an Excel macro-enabled workbook to a new computer, focusing on Trust Center, calculation, add-in, external link, and regional settings.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user moved a macro-enabled workbook to another computer and now needs to restore normal calculation and macro execution.
- Observed behavior
- After moving the workbook to a new computer, macros do not run and formulas return #VALUE! errors.
Before changing settings, open the workbook in WPS Office Spreadsheets and note whether it opens in Protected View, because Protected View blocks macros and can cause formula update issues.
Enable Macro Content and Confirm Trusted Locations in WPS Office Spreadsheets
Use this first when macros are blocked after the computer change.
Macro and #VALUE! errors after a computer change are usually caused by disabled macro content, stale external references, or calculation settings that are not configured the same as the previous machine.
Launch WPS Office, click File > Open, and select the macro-enabled Excel workbook from the new computer.
Click File > Options > Trust Center > Trust Center Settings > Macro Settings.
Choose “Enable all macros” only if your organization permits it, or choose “Disable all macros with notification” to review each file.
In Trust Center, click “Trusted Locations”, add the folder where the workbook is stored, and click OK.
Close and reopen the workbook, then run the macro again to check whether it works.

Restore Automatic Calculation and Update External References
Use this when formulas return #VALUE! or do not update after the move.
Check Add-ins and Compare Regional Settings
Use this when macros still fail or formulas show unexpected #VALUE! because of add-ins or locale differences.
Fix Macro and #VALUE! Errors in WPS Office Spreadsheets After a Computer Move
Use WPS Office Spreadsheets to diagnose and resolve macro security, calculation, external link, add-in, and regional settings issues after moving an Excel workbook to a new computer.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, click File > Open, and select the macro-enabled Excel workbook from the new computer.
- 2. Enable macro content in Trust Center: Go to File > Options > Trust Center > Trust Center Settings > Macro Settings, choose a permitted macro option, and add the workbook folder to Trusted Locations.
- 3. Turn on automatic calculation: Click Formulas > Calculation Options and select Automatic, then press F9 to recalculate every worksheet.
- 4. Update external links and add-ins: Use Data > Edit Links to repair or redirect external workbook references, and check File > Options > Add-ins for missing or disabled items.
- 5. Re-test the macro and formulas: Run the problematic macro and confirm that formulas no longer display #VALUE!; if issues continue, compare regional settings with the previous computer.

Frequently Asked Questions
Why do my Excel macros stop working on a new computer?
Macros are often blocked by Trust Center security, disabled add-ins, or broken file paths. In WPS Office Spreadsheets, open File > Options > Trust Center > Macro Settings to enable macros and verify that the workbook is in a trusted location.
How do I enable macros in WPS Office Spreadsheets?
Open File > Options > Trust Center > Trust Center Settings > Macro Settings, then select “Enable all macros” or “Disable all macros with notification”. Add the file’s folder under Trusted Locations and reopen the workbook.
Why do formulas return #VALUE! after moving a macro-enabled workbook?
#VALUE! often appears because calculation is set to Manual, external links point to unavailable paths, or regional list separators and date settings differ from the original computer. Set Formulas > Calculation Options to Automatic, update links, and compare regional settings.
Can WPS Office run Excel VBA macros?
WPS Office Spreadsheets supports many Excel/VBA macros. For best compatibility, enable macros in Trust Center and ensure any required Excel add-ins or VBA references are installed on the new computer.
How do I test whether the error is specific to one computer?
Open the same workbook on another computer that has the expected macro and add-in environment. If it works there, compare Trust Center, calculation, add-ins, external links, and regional settings with the failing computer.




