How to Safely Share Selected Excel Worksheets Without Exposing Other Data in WPS Spreadsheets
Question details
The user needs to share only selected worksheets from a workbook without exposing underlying Power Query data, the Data Model, or records belonging to other franchise organizations.
- Product
- WPS Spreadsheets / Microsoft Excel workbooks
- Device & OS
- not provided
- Scenario
- A user needs to distribute selected worksheets to different franchise organizations or recipients while keeping other sheets, Power Query output, and underlying data private.
- Observed behavior
- Hidden sheets and worksheet protection are not reliable security controls and may still allow underlying Power Query data, the Data Model, or other records to be exposed.
Before sharing, review hidden sheets, defined names, Power Query connections, and any Data Model objects that could be carried into a copy. Create a clean recipient-specific workbook or folder so the shared file contains only the intended data.
Create a Separate Filtered Workbook for Each Recipient
Use this method when a recipient should only receive selected worksheets and the workbook may contain Power Query output, Data Model objects, or other confidential data.
Workbook protection and hidden sheets are not reliable security controls. The safest approach is to create a recipient-specific workbook that contains only the filtered data the recipient is authorized to see.
For a small number of recipients this can be done manually. For large distribution, automate the same process with Power Query, Office Scripts, VBA, or other Microsoft 365 tools.
Open the Excel file in WPS Spreadsheets or Microsoft Excel and review all visible and hidden sheets, named ranges, and connections.
In Power Query, filter the records so only the intended franchise or recipient data remains in the output before loading it into the worksheet.
Right-click the worksheet tab you want to share, select Move or Copy, choose (new book) in the To book list, and click OK.
In the new workbook, delete or remove any hidden sheets, unused defined names, Power Query connections, or Data Model objects that are not required.
Save the new workbook with a recipient-specific name, upload it to OneDrive or SharePoint, and share it only with the intended person or organization.
Control Recipient Access with OneDrive or SharePoint Permissions
Use cloud permissions when you also need to limit who can open, download, or edit the shared workbook after it has been separated.
Create Recipient-Specific Workbooks in WPS Spreadsheets Before Sharing
Use WPS Spreadsheets to move selected worksheets into a new workbook, remove hidden data and connections, and share only the filtered file with each recipient.
- 1. Open the workbook in WPS Spreadsheets: Double-click the Excel file or open WPS Spreadsheets and use Menu > Open to load the source workbook.
- 2. Check the query or connection data: Go to the Data tab, open Queries & Connections if available, and confirm that only the filtered output intended for the recipient is loaded.
- 3. Move the selected worksheet to a new workbook: Right-click the worksheet tab, choose Move or Copy, select (new book) from the To book dropdown, and click OK.
- 4. Remove hidden data and save as .xlsx: In the new workbook, delete hidden sheets and unused connections or defined names, then click Menu > Save As and choose .xlsx format.
- 5. Share the cleaned file: Upload the .xlsx file to OneDrive, SharePoint, or WPS Cloud and invite only the intended recipient or organization.
Frequently Asked Questions
Can I protect sheets with a password instead of creating a new workbook?
Worksheet protection is not a reliable security control and can be bypassed. For sensitive data, create a separate recipient-specific workbook or use OneDrive/SharePoint permissions to control file access.
Does hiding a sheet prevent recipients from seeing its data?
No. Hidden sheets can be unhidden, and underlying Power Query data or the Data Model may still be accessible. Hidden sheets should not be treated as a security measure.
How do I share only one worksheet in WPS Spreadsheets?
Right-click the worksheet tab, select Move or Copy, choose (new book) in the To book list, and click OK. Save the new workbook and share that file with the intended recipient.
Will Power Query connections carry over when I copy a worksheet?
They can if the connection or query is included in the new workbook. Check the Data tab and remove unused connections, queries, or Data Model objects before saving the recipient file.
Can I automate separate workbook creation for many recipients?
Yes. For many recipients, automate filtering and workbook creation with Power Query, Office Scripts, VBA, or other Microsoft 365 tools, then distribute the files using OneDrive or SharePoint permissions.
