VBA & Macro Problems

Troubleshoot Excel Macro and #VALUE! Errors in WPS Office After Moving Computers

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

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.

Troubleshoot Excel Macro and #VALUE! Errors in WPS Office After Moving Computers
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 you start

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.

Solution 1Recommended

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.

1
Open the macro-enabled workbook

Launch WPS Office, click File > Open, and select the macro-enabled Excel workbook from the new computer.

2
Open Trust Center Macro Settings

Click File > Options > Trust Center > Trust Center Settings > Macro Settings.

3
Select a permitted macro option

Choose “Enable all macros” only if your organization permits it, or choose “Disable all macros with notification” to review each file.

4
Add the workbook folder as a trusted location

In Trust Center, click “Trusted Locations”, add the folder where the workbook is stored, and click OK.

5
Reopen and test the macro

Close and reopen the workbook, then run the macro again to check whether it works.

Enable Macro Content and Confirm Trusted Locations in WPS Office Spreadsheets
Macros should now run: If the workbook remains blocked, confirm it is not open in Protected View and that the new computer’s Office version supports the VBA references used by the file.

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. 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. 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. 3. Turn on automatic calculation: Click Formulas > Calculation Options and select Automatic, then press F9 to recalculate every worksheet.
  4. 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. 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.
Walks you through macro security, calculation options, links, add-ins, and regional settings after a computer moveOpens, edits, and saves Microsoft Excel .xlsm, .xlsx, and .xls workbooks with high compatibilityFree and lightweight desktop Office suite with a familiar ribbon interfaceLets you keep using existing VBA macros without buying Microsoft OfficeNo subscription required for routine spreadsheet and macro tasks
microsoft office alternative - wps office

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.