[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel Questions

Posted on 2013-01-04
12
Medium Priority
?
107 Views
Last Modified: 2013-01-23
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
0
Comment
Question by:gram77
[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
 
LVL 7

Accepted Solution

by:
krish5music earned 2000 total points
ID: 38744632
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.
0
 

Author Comment

by:gram77
ID: 38746190
Password is optional. Why?
0
 
LVL 7

Expert Comment

by:krish5music
ID: 38746248
Password is optional, Yes. Because it is used for high level of protection.

Thanks!
Krish.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:gram77
ID: 38746508
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?
0
 
LVL 7

Expert Comment

by:krish5music
ID: 38747758
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
0
 

Author Comment

by:gram77
ID: 38748212
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?
0
 
LVL 7

Assisted Solution

by:krish5music
krish5music earned 2000 total points
ID: 38748226
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.
0
 

Author Comment

by:gram77
ID: 38750143
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?
0
 
LVL 7

Expert Comment

by:krish5music
ID: 38750573
could you please share the screenshot?

Thanks!
Krish.
0
 

Author Comment

by:gram77
ID: 38754596
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
0
 
LVL 7

Expert Comment

by:krish5music
ID: 38754908
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.
0
 

Author Comment

by:gram77
ID: 38810475
I have protected the worksheet.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question