In today’s world, one of the most used platforms for people to make accounting books, manage the administration, accounts and formulas of a company or activity is Excel. With it, you can do everything mentioned above and more.Again, it is worth mentioning that, thanks to the new update, currently we can find Options for sharing group files.
There is a way to use the same Excel spreadsheet at the same time, share information and edit calculations previously made. To do this, you must first download Excel from its official website and follow each of the steps mentioned below:
What are the useful options in the file sharing section in Excel?
To share the created Excel file with other users, this option is very simple as you can just click «Share» after the file is saved will show many features Consider sending. You can reverse the data in a text string, or enable the recipient of the file to edit, view only, or even prevent them from downloading the spreadsheet.
If you want them to edit or just view the file
If what you want is that time share excel file, the person who will receive it can edit it, or in this case, you want to avoid this, you can block or enable editing. You should consider the following:
- To enable editing options while locked, you must first select the spreadsheet or cell you want to unlock for editing.
- Right click and select the «Format Cells» option, then you should go to the «Protect» option, which will be deactivated if it is blocked.
Now, if you want to do the opposite of what was mentioned above, you can also lock a specific cell Or the entire spreadsheet so that others who receive the file cannot edit it.
- You have to select the cells you don’t want to edit, or in this case, the entire spreadsheet.
- Can set specific password to unlock protection options
- Click on the «review» option and enter «Protect sheet»
- You can select elements that other users can edit when they click Allow
To prevent them from downloading the book
- For users who receive the spreadsheet, an option can be set so that they don’t download it.
- Click «File» and then «Info»
- Select Protect Bookbox and the password will be encrypted.
- Once established, they must add said password every time it is shared and downloaded by a third party.
Add comments to shared files
When sending documents in Excel, the platform gives you the opportunity before sharing Add comments to shared files So whoever receives it will be able to read what is written as a note attached to the shipment.
What are some ways to share Excel documents?
Several features are stored in the Share option to help multiple people use Excel at home. These will be explained below:
Click on «File»
One of the ways to share a document or spreadsheet on the Excel platform is through the File option. This option is at the top of the spreadsheet, especially in the left corner.Several options will appear there, among which is «share»
From the program’s taskbar
In the taskbar of the Excel program, there is also the «Share» option, another of the most comfortable and easiest ways to share files with others.
If you want to share in other ways
If the Excel document or file is not sent directly from the platform, can be sent by other meansvia email or a file browser, select the document and click Share, choosing the most appropriate option.
For older versions of Excel
For very old versions of Excel, in principle you should make sure that «Share» is already available, as older versions are usually not compatible with the «Share» option, however, if it’s not that old, usually the share tool is located at in the «Review» option at the top of the screen.
Why doesn’t the link open your shared Excel file?
As mentioned earlier, the Excel program has several important functions that directly help us calculate anything, even the standard error of the mean. However, in some cases, which usually happens when a link to an Excel file is shared, it doesn’t open to the person receiving it.
There could be several reasons for this, the main one being that users don’t have as up-to-date comments as the person who sent the document, so they reject very old versions. Versions must be constantly updated, as the oldest version has several limited new options.Also, by not opening the file, this can happen Excel has not been downloaded from your primary platform.