answersLogoWhite

0


Best Answer

The biggest con is the risk of forgetting the password and not being able to do anything with the file. There is no way of breaking the password to open it if the password is forgotten. If a password is just being used to protect some cells there is the risk of not having the correct ones protected or leaving ones that should be protected as unprotected.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

You can keep your entire workbook private. You can prevent people changing data in some cells. You can be fairly sure that it is locked and that no one can make changes if they do not have the password.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the cons of using password protection in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the Pros and cons of the social contract theory?

Pros include the idea of common good, protection of individual rights, and establishment of order in society. Cons involve concerns about the legitimacy of individual consent, potential for exploitation by those in power, and lack of enforcement mechanisms.


Suggestions for a Club Penguin money maker?

no such thing, they are all cons to try and get your password


What are the pros and cons of using Visual Basic on Excel?

Excel has a variation of Visual BASIC built into it, called Visual BASIC for Applications, commonly called VBA. The advantage of using VBA is that it greatly enhances what you can do with Excel. It gives you greater power to do things with Excel that are difficult or impossible with Excel formulas. It can help automate tasks by creating simple macros. It brings the powers of programming to Excel.The main disadvantage is the complexity of VBA if you are not familiar with it. It takes time to learn how to use it, and even then it can be complicated to get it to do what you want. If you have knowledge of Visual BASIC that will help, but there are aspects of VBA that are especially for working with Excel. There is the danger to ruining your data if you do something wrong with VBA.


What are pros and cons of using benzene?

The pros of benzene is apple and the cons of benzene is banana.


What are the pros and cons of using an HVAC system in a residential building?

pros comfort cons no comfort if you want to heat or cool you will be using some form of hvac


What are the pros and cons of using lng?

Pros green safe non corrosive odorless nontoxic CONS nonrenewable


What are the pros and cons of using gasoline powered cars?

Pros: Car moves Cons: Car pollutes atmosphere


Can you do anything about the cons of using diamonds?

You can refuse to use diamonds.


What are the pros and cons of using a market intermediary?

What are the pros and cons of using a market intermediary?


How to make sentence using pros and cons?

After weighing up the pros and cons, Albert decided against buying a new car.


What cons are there to using free website designers?

The cons in using free website designers are many fold. First, there is no guarantee as to the quality and functionality of their work. Second, you do not own any of the work as you have not paid for it.


What are the pros and cons of laser for using on bikinie area?

THE PROS ARE THAT YOU DO NOT HAVE TO SHAVE DOWN THERE ANYMORE. THE CONS ARE THEY MIGHT MISS AND ZAPP YOUR ROSE BUD.