+4 votes
232 views
How to protect an Excel 2019, 2016 file for read-only

in Office by (552k points)
reopened | 232 views

1 Answer

+5 votes
Best answer

How to protect a read-only file in Excel 2019

The data security in Excel 2160 0 2019 is one of the priorities that we must always keep in mind since, if we are working with large amounts of data and the value of any cell is modified, accidentally or not, this will change all the design, values ​​and the expected result created confusion and errors when delivering files or executing relevant tasks..

A practical way to avoid this type of incident is to establish that file in read-only mode , so, a user without the respective permissions will not be able to modify any of the content of the sheet and therefore no procedure that is within she. TechnoWikis will explain how to create a protected read-only file in Excel 2019 being equally valid for versions of Excel 2016.

To keep up, remember to subscribe to our YouTube channel! SUBSCRIBE

How to protect a read-only file in Excel 2019

Step 1

To achieve this, we must go to the sheet that we are going to establish as read-only, go to the “File” menu and in the “Information” section we must click on the “Protect book” option and click on the option “Always open as read only":

image

Step 2

By selecting this option we can see that this option is highlighted in Excel 2019: image
Step 3

We proceed to close the book and save the changes, and when we try to access the book again we will see the following message: image
Step 4

As we can see, this message indicates that this book can only be opened in reading mode, so that no change can be applied, if we click on the Yes button we can see in the title bar the legend "Read only": image
Step 5

In this way it will not be possible to make any changes to the book or its information as the following message will be displayed: image
Step 6

To recover the edition of the book we must go to File / Options / Save as: image
Step 7

Now we define the path where the file is to be saved and we can see that it is automatically created with the name Copy of “File”. By saving this copy it will be possible to edit your data and keep the same information from the read-only file. image

Thus, we have learned to create a read-only file in Excel 2016 or 2019..


by (3.5m points)
edited

Related questions

+5 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (552k points) | 288 views
+5 votes
1 answer
asked Sep 28, 2019 in Office by backtothefuture (552k points) | 214 views
+3 votes
1 answer
asked Jun 22, 2019 in Office by backtothefuture (552k points) | 265 views
+3 votes
1 answer
asked Sep 20, 2019 in Office by backtothefuture (552k points) | 229 views
+4 votes
1 answer
asked Sep 20, 2019 in Office by backtothefuture (552k points) | 290 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users