Hi, I have an excel document I've been working on for a while. Today either I or my co-worker accidentally made some kind of change so that now this excel document won't allow me to Move or Copy any of the sheets. This option is grayed out when I right click on the sheet's tab. The sheets are generally protected, but even when I unprotect them it still won't allow me to access this option.
Try unprotecting the workbook.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
As I stated above, even when the worksheet/workbook is unprotected, it still won't allow me this option.
Also, before today even if the worksheet was protected, it would still allow us to move/copy, which was really helpful.
You stated above that you've tried unprotecting the worksheet(s).
I'm suggesting you unprotect the workbook.
Oh, sorry. The workbook is also unprotected
I just tried to add a new worksheet, & it won't allow me to do that either.
Attach your workbook, let's have a look.
Here it is. If anything is still protected, the password to unprotect is blbcadmin
That workbook is protected (with a password).
Unprotect it, using the correct password, and your problems will be solved.
You do know the password, right?
Okay, I'm such an idiot. The workbook WAS protected.
sorry to waste your time!! But thanks for the help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks