Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save single excel worksheet out of workbook in excel 2007
Have a multiple worksheet file and I'm trying to save just a single
worksheet. Just upgraded to excel 2007 and this is no longer an option in the "save as" options. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
save single excel worksheet out of workbook in excel 2007
Right click on the sheet tab and choose "Move or Copy"
To Book: new book Then check the "create a copy" checkbox You can save this file now With code it is one line of code to create a new file with the sheet If you need help with that post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rokbroscore" wrote in message ... Have a multiple worksheet file and I'm trying to save just a single worksheet. Just upgraded to excel 2007 and this is no longer an option in the "save as" options. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
save single excel worksheet out of workbook in excel 2007
Saving a single worksheet was never an option in any version.
You have to copy that sheet to anew book and save that. Gord Dibben MS Excel MVP On Fri, 13 Jul 2007 07:06:03 -0700, rokbroscore wrote: Have a multiple worksheet file and I'm trying to save just a single worksheet. Just upgraded to excel 2007 and this is no longer an option in the "save as" options. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I e mail a single worksheet in excel 2007 | Excel Discussion (Misc queries) | |||
How do i send a single worksheet in excel 2007? | Excel Discussion (Misc queries) | |||
send single worksheet from excel 2007 | Excel Discussion (Misc queries) | |||
How do I save a single spreadsheet in a workbook in excel | Excel Worksheet Functions | |||
Save a single worksheet in Excel as a single file. | New Users to Excel |