File Sharing Problems

How to View Updated Excel Macro Data on a Phone Without Editing in WPS Office

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

The user needs to view updated Excel macro data on a phone without editing the macro-enabled .xlsm workbook or losing VBA functionality, by generating a separate read-only .xlsx copy.

How to View Updated Excel Macro Data on a Phone Without Editing in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
A macro-enabled .xlsm workbook is maintained on a computer that collects and refreshes data, and the user wants to review the refreshed values, tables, or reports on a phone.
Observed behavior
When the .xlsm file is shared through a cloud service or opened directly on a phone, it may be converted to .xlsx, removing VBA functionality and creating later replacement conflicts; a read-only mobile viewing copy is needed.
Before you start

Confirm that the master .xlsm workbook is saved on the computer where the VBA macro runs, and make sure you are signed in to the same OneDrive, SharePoint, or other cloud folder on both the computer and the phone.

Solution 1Recommended

Export a Read-Only .xlsx Copy with a Macro for Phone Viewing

Use this when the .xlsm workbook must keep its VBA functionality and the refreshed results need to be viewed frequently on a phone.

Keep the macro-enabled .xlsm file on the computer that collects and refreshes the data. The macro copies only the required values, tables, or reports into a separate .xlsx workbook, so the original VBA project is not exposed or changed by the mobile app.

1
Open the macro-enabled workbook on the computer

Open the .xlsm file in WPS Office Spreadsheets on the computer where the macro is maintained and the data is refreshed.

2
Add or edit the export macro

Open the Visual Basic Editor from Tools > Macro > Visual Basic Editor, then insert or edit a macro that copies the required values, tables, or reports into a new workbook.

3
Save the output as .xlsx in a cloud folder

In the macro, use SaveAs to save the new workbook as an .xlsx file to a local OneDrive, SharePoint, or other cloud-synced folder.

4
Run the macro to refresh the mobile copy

Run the macro whenever the source data is refreshed so the .xlsx output contains the latest values.

5
View the .xlsx file on the phone

On the phone, open the OneDrive or SharePoint app and tap the exported .xlsx file to view the updated data.

Export a Read-Only .xlsx Copy with a Macro for Phone Viewing
Read-only workflow: The phone copy stays separate from the .xlsm master, so viewing it does not edit or replace the macro-enabled workbook.

Use WPS Office to View Updated Excel Macro Data on Your Phone Without Editing the .xlsm File

Keep the macro-enabled .xlsm workbook on your computer, then export the refreshed values into a separate .xlsx file saved to OneDrive or SharePoint. WPS Office opens the read-only .xlsx copy on your phone without changing or replacing the original macro workbook.

  1. 1. Open the .xlsm workbook on your PC: Launch WPS Office Spreadsheets and open the macro-enabled .xlsm workbook on the computer that collects and refreshes the data.
  2. 2. Open the macro editor: Go to Tools > Macro > Visual Basic Editor in WPS Office Spreadsheets to access the existing macro or add a new export macro.
  3. 3. Save results as .xlsx in the cloud: In the macro, copy the values, tables, or reports into a new workbook and save it as .xlsx to your OneDrive, SharePoint, or other cloud-synced folder.
  4. 4. Run the macro after data updates: Run the macro whenever the source data is refreshed so the exported .xlsx file contains the latest numbers.
  5. 5. View on your phone: Open the OneDrive or SharePoint app on the phone and tap the .xlsx output to view the updated macro data.
Preserves VBA functionality in the original .xlsm workbookCreates a lightweight .xlsx view for safe mobile accessFull compatibility with Microsoft Excel .xlsm and .xlsx formatsFree WPS Office opens cloud .xlsx files without conversionFamiliar spreadsheet interface makes phone viewing easy
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel macro file lose its macros when I open it on a phone?

Many mobile spreadsheet apps do not run VBA and may open a macro-enabled .xlsm workbook as a regular .xlsx file. This removes or hides the macros, so it is safer to create a separate .xlsx output for phone viewing.

Can I update the .xlsx viewing copy without running the macro on the computer?

The macro must run on the computer where the .xlsm workbook and its data connections are maintained. After the macro runs, it can save the updated .xlsx to a cloud folder that automatically syncs to your phone.

Will creating a separate .xlsx copy overwrite my original .xlsm file?

No, if you save with a different file name or to a different cloud folder. Keep the .xlsx as a read-only output and do not edit it on the phone, which prevents replacement conflicts with the original .xlsm.

Can WPS Office open both .xlsm and .xlsx files?

Yes. WPS Office Spreadsheets is compatible with Microsoft Excel .xlsm and .xlsx formats. However, for mobile viewing, use the .xlsx output to avoid VBA limitations and preserve the macro workbook.