Hi I've a shared workbook. But it doesn't allow me copy/move or delete sheet(s). How can I solve this problem? Or How can I undo sharing? (I don't remember how I Shared :) )
3 Answers
you might want to change the permission for the workbook folder.check if the workbook has a Protection area where you can change permissions from within the workbook. another would be to check the permissions that are allowed in the file itself IE right click and go to sharing and security then set the permisions for EVERYONE for everything.
Click "Review, then "Share Workbook". A window will pop up with two tabs, under "Editing" uncheck the box marked "Allow changes by more than one user at a the same time. This also allows workbook merging"
None of the above things worked for me, I am not the original creator of the shared XLS file I am working on though. If you uncheck the box marked "Allow changes by more than one user at the same time" even when you share the workbook again other users will be unable to save their changes, so that wont' work for me either.
What DID work was:
- Select the entire worksheet you want to copy (by clicking in the top left corner between row A & column 1).
- In a new blank worksheet Paste > Formatting (this pastes only the formatting, no text or numbers).
- Go back to original worksheet, select the columns, and Copy.
- Paste (just regular paste) them into the new tab by selecting the columns in the new tab before you click Paste.
This copied everything perfectly for me. Hope this helps!!!