Save Worksheets to Separate Files
The Save Worksheets to Separate Files tool will take each worksheet, move it to a separate file and save it under its own workbook.
Form Fields
- Worksheet listing grid: Includes a checkbox for indicating whether to extract each worksheet, the sheet name, and the output file name (double-click the name to edit it).
- Save to folder: Allows you to specify where to save the extracted sheets.
- Remove saved workbooks: Indicates whether to make a copy of the extracted sheets or to fully remove them from the current workbook.
Note: If you choose to remove the sheets from the current workbook, there must be at least one sheet remaining in the workbook. Spreadspeed will default to retaining the first sheet.