For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
6 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel Questions
Posted on 2013-01-04
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
6
12 Comments
Hi,
As you mentioned that, you have just checked in structure option and checked out, it can allow you to edit your documents, until you set password for worksheet.
For copying the drop down menu.
Select the range
Goto Edit>Paste Special>Validation>OK
Let me know if it helps.
Thanks!
Krish.
As you mentioned that, you have just checked in structure option and checked out, it can allow you to edit your documents, until you set password for worksheet.
For copying the drop down menu.
Select the range
Goto Edit>Paste Special>Validation>OK
Let me know if it helps.
Thanks!
Krish.
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?
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
If you want to protect your sheet then you have to use protect sheet option.
Excel-protect.jpg
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?
What kind of changes you did?
Ok. Let's do the following steps and test it.
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.
As i mentioned earlier, the protect workbook structure, windows options prevent unwanted changes to the sheets and not the content.
Let me know if you any questions.
Thanks!
Krish.
Ok. Let's do the following steps and test it.
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.
As i mentioned earlier, the protect workbook structure, windows options prevent unwanted changes to the sheets and not the content.
Let me know if you any questions.
Thanks!
Krish.
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?
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?
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
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.
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.
Featured Post
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month6 days, 17 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.