Insert a worksheet from different workbook

[Guest]

Hi
I have a shared workbook. I want to insert worksheet from a different
workbook into this shared workbook. but it is not possible. the drag and drop
doesn't work. And also i can't delete any worksheets in the shared workbook.
does anyone have any idea?
thanks

 

[Guest]

here's how you can do this

1) on the tools > share workbook menu, check that you are the only one with
the workbook open. get the others to close it.

2) unshare the workbook.

3) now do what you have to do with the sheets

4) share it again and let the other users know they can go back in