How to View Updated Excel Macro Data on a Phone Without Editing in WPS Office
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.

- 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.
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.
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.
Open the .xlsm file in WPS Office Spreadsheets on the computer where the macro is maintained and the data is refreshed.
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.
In the macro, use SaveAs to save the new workbook as an .xlsx file to a local OneDrive, SharePoint, or other cloud-synced folder.
Run the macro whenever the source data is refreshed so the .xlsx output contains the latest values.
On the phone, open the OneDrive or SharePoint app and tap the exported .xlsx file to view the updated data.

Manually Save a View-Only .xlsx Copy for Occasional Phone Viewing
Use this for one-off viewing when you do not want to add or run a macro.
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. 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. 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. 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. 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. View on your phone: Open the OneDrive or SharePoint app on the phone and tap the .xlsx output to view the updated macro data.

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.




