ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert a worksheet from different workbook (https://www.excelbanter.com/excel-discussion-misc-queries/119589-insert-worksheet-different-workbook.html)

Suraj

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

Allllen

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



All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com