| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a worksheet from different workbook
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert a worksheet from different workbook
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 -- Allllen "Suraj" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| Can't insert worksheet in excel workbook? | Excel Discussion (Misc queries) | |||
| Macro or OLE method to insert worksheet from template workbook | Excel Discussion (Misc queries) | |||
| How do I protect a worksheet from being opened inside a workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
