Follow these steps to delete all empty sheets from an Excel workbook:
1. Select the special process "[117] (*.XLS) Delete all empty sheets within workbook" from the Special Process drop down list. The file format is automatically set as *.XLS.
2. Next select the input and output files. If the input and output files are the same, sheets will be deleted from the input workbook. If the input and output files specified are different, a new output workbook will be created.
3. Optional: Click the Add (or ALT+A) button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.
4. Click the Convert (or F5) button to execute the process.
Additional Details
This special process is used to clean up a workbook by removing any empty worksheets. The worksheet must be completely empty for it to be deleted. Whitespace characters such as space, tab etc that appear hidden in a sheet can keep it from being deleted.
Additionally, you can use this special process to delete empty sheets from a single workbook file, or a whole folder (and sub-folders) of workbooks. There must be at least one sheet in a workbook left. In other words, you cannot delete all the sheets in a workbook.
Note: If you name a sheet with only numbers, you will need to use quote marks around that name. For example, if you name a sheet 32, when you specify the Input Sheet you must input "32" with the quotes around the name so Convert XLS knows it is a name and not an index number for the sheet. If you browse for the file and click to select it, you will still need to manually add the quotes.