View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Excel file too big even when I delete all cells

You might have some named ranges defined in the workbook which are no
longer needed. Another common reason for a workbook to increase in
size is for there to be some graphic objects which are no longer
needed. Check also that the file is saved as the latest version, not
as a hybrid (i.e. Excel 5.0/95 workbook).

Hope this helps.

Pete

On Feb 28, 5:35*am, wrote:
My file size is 700 KB for a spreadsheet with little text and few
formulas with links but no macros. *I deleted the cells to the right
and bottom of the cells being used and the size stays the same; even
deleting all of the cells in the workbook does not change the size. *I
cut the spreadsheet and pasted into a new file and the new file has
the same size as the original. *Any ideas? *Thanks!