Share Personalized Excel Data Securely with Employees in WPS Office
Question details
Automate distribution of weekly employee values from a master Excel workbook so each employee receives only their own filtered data without accessing the master file or other employees' data.
- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- A manager or HR team maintains a master workbook of employee values and needs to send each employee their individual row or subset each week.
- Observed behavior
- Each employee receives only their own filtered data through a permission-controlled folder or workbook, while the master data remains private.
Store the source data in a structured Excel table with a unique employee identifier column, such as employee ID or email, and create a separate folder for each employee before running any distribution workflow.
Set Up a Privacy-Controlled Master Table and Employee Folders
Use this foundation when you want the master data to stay private and each employee to have a dedicated destination folder.
This creates the structure required by Power Query or VBA and enforces privacy at the folder level.
Open the master workbook in WPS Office Excel, select the data range, and click Insert > Table to create a structured table with a unique employee identifier column.
In your shared drive or network location, create one subfolder per employee and name it with the employee ID or email used in the master table.
Right-click each employee folder, open sharing or permissions settings, and grant access only to that employee and authorized administrators.
Use Power Query to Filter and Export Each Employee’s Data
Use this when you want a repeatable, low-code way to generate individual employee files from the master table.
Automate Recurring Distribution with VBA
Use this when you need scheduled or one-click distribution after the folder structure is ready.
Distribute Personalized Excel Data Securely with WPS Office Excel
Use WPS Office Excel to structure your master data, filter by employee, and save each result to permission-controlled folders—so employees only see their own values while your source workbook stays private.
- 1. Open your master workbook in WPS Office Excel: Launch WPS Office Excel and open the workbook that contains the employee values.
- 2. Format the data as a table: Select the data range and click Insert > Table, then confirm the employee identifier column is included.
- 3. Filter by employee: Use Power Query from Data > Get Data or apply AutoFilter to isolate a single employee’s rows.
- 4. Save to the employee’s private folder: Save the filtered workbook or CSV into the employee-specific folder that has restricted permissions.
- 5. Repeat for remaining employees: Repeat the filter and save steps for each employee, or automate the loop with a VBA macro.
Frequently Asked Questions
How do I prevent employees from opening the master Excel file?
Store the master workbook outside employee folders and set folder permissions so employees have no read access. You can also protect the workbook in WPS Office Excel via File > Info > Protect Workbook.
Can I use Power Query in WPS Office Excel to create separate employee files?
Yes. Load the master table through Data > Get Data or Import Data, filter the employee ID column for one employee, then close and load the query to a new workbook saved in that employee's folder.
How can I automate the process weekly?
Build a VBA macro that loops through employee IDs and saves filtered copies, then use Windows Task Scheduler to open the workbook and run the macro on the desired weekly schedule.
What identifier should I use in the master table?
Use a unique and stable value such as employee ID or corporate email address. Avoid names alone because duplicates can expose the wrong data.
Do employee workbooks need to be .xlsx?
Yes, .xlsx is recommended for WPS Office Excel and Microsoft Excel compatibility. If you use VBA automation, save the master as an .xlsm macro-enabled workbook.
