Catalog

How to Make Spreadsheet Editable for Multiple Users in Excel - A Step-By-Step Guide

November 3, 2023 2.3K views

Collaboration in spreadsheets is the heart of productive teamwork. Imagine being able to analyze and solve issues from a user's perspective. This guide empowers you to enhance Excel's collaborative capabilities, transforming your approach to data. Let's dive in!

Part 1: Easy Steps to Share Your Editable Spreadsheets in Excel

If you're using Excel, you might find that the shared workbooks feature is not readily available. To enable it, follow these six steps to add it to your Quick Access Toolbar in your spreadsheet.

Step 1: Locate Hidden Shared Workbooks Feature

If you have Excel, you may find the shared workbooks feature is hidden. To use it, you'll need to bring it back to the Quick Access Toolbar of your spreadsheet.

Step 2: Access Excel Options

Click "File" at the top left of your screen.

Select "Options" at the bottom of the left column.

click option


Step 3: Choose Quick Access Toolbar

In the Options dialog box, choose "Quick Access Toolbar" on the left.

Click Access toolbar


Step 4: Include Shared Workbooks

In the "Choose Commands From" dropdown menu, pick "All Commands."

select all commands


From this list, select "Shared Workbooks (Legacy)" and click "Add."

Click Add


Step 5: Add Other Legacy Features

From the same list, add "Track Changes (Legacy)", "Protect Sharing (Legacy)", and "Compare and Merge Workbooks."

compare


track


protect


Step 6: Confirm Changes

Click "OK.”

Sharing editable spreadsheets in Excel is essential for effective collaboration. Here's a step-by-step tutorial:

Step 1: Share Your Excel Sheet

Click "Share" in the top-right corner.

Use email or a shareable link to invite collaborators.

Click Share


Step 2: Choose Editing Permissions

Set editing access to 'Can Edit' for co-authoring.

Select Edit


Step 3: Real-Time Collaboration

Once your team accepts, they can edit alongside you.

Collaborators are indicated by their names or initials in the top-right corner. Active cells are highlighted with unique colors.

Part 2: How to Change Spreadsheets from read-only to Editable in Excel?

Situation 1: When the File Is in Read-Only Mode

Step 1: Open Microsoft Excel.

Step 2: Click on "File" in the top menu.

Step 3: Select "Options" from the menu on the left.

Select option


Step 4: Choose "Trust Center" on the left of the PowerPoint Options window.

Click trust center


Step 5: Click "Trust Center Settings."

Click "Trust Center Settings."


Step 6: In the Trust Center Settings window, select "Protected View" on the left.

Click protected view


Step 7: Uncheck the following options: "Enable Protected View for files originating from the Internet," "Enable Protected View for files located in potentially unsafe locations," and "Enable Protected View for Outlook attachments."

Uncheck option


Step 8: Click "OK" in the Excel Options window.

Click Ok


Situation 2: When the Excel File is Marked as Final

Click the “Edit Anyway” button next to the "MARKED AS FINAL" notification on the top of the sheet.

Click edit anyway


Situation 3: When the Excel File is Protected with Modifying Password

If you don't know the password, open the file in read-only mode, press "CTRL+A" to select the whole worksheet, and then press "CTRL+C" and "CTRL+V" to copy and paste the content into a new worksheet.

If you know the password, type it, go to "File," click on "Save As," and delete the password in the "Password to modify" field in the "General Options" menu.

delete


Part 3: How to Edit Excel Spreadsheet with WPS Spreadsheet for Free?

WPS Spreadsheet offers a versatile and user-friendly solution for handling Excel spreadsheets. Its compatibility with major office suites, common file formats, and support for various devices makes it a powerful tool for both personal and professional use.

WPS Spreadsheet has been a reliable companion in my productivity journey. Its lightweight nature ensures that even on less powerful devices, I can work without lag or performance issues. The ability to access and edit spreadsheets online provides flexibility that's crucial for today's work environment.

Pros of WPS Spreadsheet:

  • Efficiency: WPS Spreadsheet operates smoothly even on less powerful devices, ensuring quick and responsive performance.

  • Cloud Integration: With seamless cloud-based document access, WPS Spreadsheet promotes collaboration and provides unmatched flexibility.

  • Reliability: WPS Spreadsheet maintains a secure and stable environment, minimizing the potential for system crashes and data loss.

Steps to Download WPS Office

Step 1: Navigate to the WPS Office website.

Step 2: Select the WPS Spreadsheet version compatible with your device and initiate the download by clicking the Free Download button.

select option


Step 3: After the download finishes, double-click on the downloaded file to initiate the installation process.

Step 4: Adhere to the on-screen instructions for a successful installation.

instruction


Step 5: Upon installation completion, open WPS Office and access the Spreadsheet program.

select sheets


Easy Steps to Share Your WPS Spreadsheet for Multiple Users.

Step 1: Open the Excel file or spreadsheet in WPS Office that you want to share. Look for the "Share" option located in the upper right corner, indicated by an arrow pointing in an upper-right direction. Click on it.

Click Share


Step 2: In the "Share and Collaborate" window that appears, select the "Anyone with the link can edit" option or "Anyone with the link can view", then click "Create link."

Select options


Step 3: Once you've created the link, you can easily share it via your preferred method.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQS:

What if I forget the password I set to protect my worksheet? 

If you forget the password, you won't be able to make changes. Ensure you keep the password safe and accessible only to trusted individuals.

How can I track changes made by different collaborators?

Excel provides a "Track Changes" feature that allows you to see who made what changes and when. This can be particularly helpful for version control.

Can I set specific permissions for different collaborators in Excel to control their access to certain parts of the spreadsheet?

Yes, Excel allows you to set specific permissions for different collaborators. You can control their access to certain parts of the spreadsheet by using features like sheet protection, password-protected ranges, and custom permission settings.

What are the data security measures to consider when collaborating on sensitive information in Excel with multiple users?

To secure sensitive Excel data during collaboration, employ strong passwords, encryption, and access control. Maintain backups, label sensitive data, and use version control. Share files securely, apply data loss prevention, and educate users for a safe collaborative environment.

Summary

In conclusion, this comprehensive guide to collaborative Excel editing in 2023 brings a new level of efficiency and productivity to your team. From sharing editable spreadsheets to managing data security and harnessing the capabilities of WPS Spreadsheet, you now have the tools to excel in teamwork. Collaboration is no longer a challenge but a seamless and empowering experience. Make 2023 the year your team elevates their Excel game.

Overall, if you're looking for a free and capable alternative to Microsoft Office that is compatible with a wide range of file formats and offers a user-friendly experience, WPS Office is definitely worth considering. Whether you're a student, professional, or anyone in between, WPS Office can streamline your document creation and collaboration tasks.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.