Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Dividing A Workbook Into Smaller Portions
Help! I've created several workbooks that are taking too long to open and close. I want to split the worksheets and make smaller workbooks. Is there any easy way to do this? Also: The "Delete Sheet" option is not available, apparently due to these workbooks being on a shared drive. I have tried moving them off of the shared drive so that I can delete and/or make changes to some of the worksheets, but I am still unable to do this. Can anyone tell me how I can make it so this option is available again? Thank you for any assistance offered! :) -- calimari ------------------------------------------------------------------------ calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537 View this thread: http://www.excelforum.com/showthread...hreadid=386222 |
#2
|
|||
|
|||
I'd guess that it's workbook protection (tools|protection|protect workbook)
that's causing the "delete sheet" unavailability problem. And if you can copy the sheets to a new workbook one by one edit|move or copy sheet Then save each of those workbooks (with just one worksheet) as your smaller files. Personally, if I have formulas on one sheet that refer to other worksheets, I wouldn't do this. calimari wrote: Help! I've created several workbooks that are taking too long to open and close. I want to split the worksheets and make smaller workbooks. Is there any easy way to do this? Also: The "Delete Sheet" option is not available, apparently due to these workbooks being on a shared drive. I have tried moving them off of the shared drive so that I can delete and/or make changes to some of the worksheets, but I am still unable to do this. Can anyone tell me how I can make it so this option is available again? Thank you for any assistance offered! :) -- calimari ------------------------------------------------------------------------ calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537 View this thread: http://www.excelforum.com/showthread...hreadid=386222 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |