Split Wokbook

[Wanna Learn]

Hello I have a workbook that has 35 worksheets. I want to split the
workbook and create 2 workbooks. The worksheets are linked and have formulas
, so I need to keep the links and the formulas in the new workbook. What is
the fastest way to do this? Thanks

 

[Dave Peterson]

First, do this against a copy of your workbook--just in case.

Open this copy
Select the sheets to move
(click on the first tab and ctrl-click on subsequent)
Edit|Move or Copy Sheets)
(Don't make a copy!)
Move to a new workbook.

Save both "halves" as nice names.

Close excel and reopen each half separately to test to see if it worked.

 

[Wanna Learn]

Dave Thank you

First, do this against a copy of your workbook--just in case.

Open this copy
Select the sheets to move
(click on the first tab and ctrl-click on subsequent)
Edit|Move or Copy Sheets)
(Don't make a copy!)
Move to a new workbook.

Save both "halves" as nice names.

Close excel and reopen each half separately to test to see if it worked.