| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a single spreadsheet in a workbook in excel
I've got a workbook with multiple calculations on each worksheet, one
worksheet is a report sheet and need to be saved without the formulas and references to the other sheets. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I save a single spreadsheet in a workbook in excel
Hi, Right Click on the report sheet. Select move or copy. Tick the copy option. Next click the drop down "to book" and select the new book option. Then select all cells and copy, next right click and choose Paste special and then values. Hope that's what you wanted. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561692 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an excel spreadsheet as a comma-delimited ASCII file | Excel Discussion (Misc queries) | |||
| save excel workbook | Excel Discussion (Misc queries) | |||
| How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
| save excel spreadsheet as a csv file | Excel Worksheet Functions | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Linear Mode
