I have a 5.91Mb file. No preformance issues, recalcs in under a second. Just looking for ways ro reduce file size, because we have to e-mail it around.
Trying to highlight all worksheets and make a copy in a new workbook result in a Disk Full Error. (It isn't)
Over to Excel 2000 SR1. File Save As works.. Export all worksheets works. The file size stays 5.91Mb. Saving as HTML results in a 28.7Kb file. Now, never having done this before, is that sort of reduction in size usual? When I re-open the HTML file and do a Save As .xls, I'm back to a 5.91Mb file. Interestingly excel complains when you re-open the HTML file that it encountered problems with the conditional formattingin the sheet.
Any thoughts, observations?