Avatar of gram77
gram77
Flag for India asked on

Excel Questions

1.I protected my workbook (Review --> Protect Workbook --> Protect workbook for structure) and checked it in, when i checked it out again it allowed me to make changes to it and check it in.
How do i check if my workbook has been protected for editing or not. Is it that excel is allowing me to edit the document since it recognizes my login credentials?

2. When i copy text from one worksheet to another, the dropdown menu etc.. are not copied. How do i copy such that each row contains the dropdown menu
Microsoft Office

Avatar of undefined
Last Comment
gram77

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
krish5music

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gram77

ASKER
Password is optional. Why?
krish5music

Password is optional, Yes. Because it is used for high level of protection.

Thanks!
Krish.
gram77

ASKER
No my question is, if i can do Review --> Protect Workbook --> Protect workbook for structure without password protection, and after checkin/checkout i am still able to modify my excel, what protection does this setting provide?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
krish5music

It prevent unwanted changes to the structure of the workbook moving, deleting, or adding sheets. Please find attached screenshot.

If you want to protect your sheet then you have to use protect sheet option.
Excel-protect.jpg
gram77

ASKER
So comming back to the same question : Even after doing the security settings without the password, excel should disallow me from doing the changes. But it does allow me to make changes why?
SOLUTION
krish5music

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
gram77

ASKER
reply:
1.open a new excel or the existing one.
2.Go to Sheet 1 and right click. you can see the options to  insert, delete, move, copy the sheets are enabled.
3. Go to Review --> Protect Workbook --> Protect workbook structure and save.
4. Again, right click on the Sheet 1 and now you can see all the options are disabled >>reply, yes on right click i do see options to insert.. and delete.. why?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
krish5music

could you please share the screenshot?

Thanks!
Krish.
gram77

ASKER
I entered a password and saved the document, still when I reopen it and right click on it I am able to see all editing options. Maybe excel is able to see my login and it is able to know that the person is the same as the one who created the password for it thus it gives me full access. Maybe I need to open the excel in someone else's computer and check if he can see all editing options and excellent asks him for a password for editing it or not
krish5music

Please clarify .

After enabling the protect workbook structure or with password, are you right clicking on the cells or the sheets?

Because, you can test this option, when you right click on the sheets and not at the cells area.

If you still able to see all the options are enabled, please share the screenshot.

Thanks!
Krish.
Your help has saved me hundreds of hours of internet surfing.
fblack61
gram77

ASKER
I have protected the worksheet.