v. large file for small data

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I have a spreadsheet that was sent via email that contains
only a small amount of data (fits on screen) but has a
size of 14MB. I have copied the data to another sheet
(values only) and that sheet is only 18KB. When I select
all on the original and delete it all the size is still
14MB - what the...

Any help ideas appreciated
 
Most likely the used-range is "exploded". Select the column to the right of
the last column of data. Hold down the "Shift" key. Hit "End" and the
right arrow. Release the "Shift" key. Right click on a selected column
heading and select "Delete".

Select the row beneath the last row of actual data. Hold down the "Shift"
key. Hit "End" and the down arrow. Release the "Shift" key. Right click
on a row heading and select "Delete".

Save file. Close file. Reopen file. Do this to any worksheets within the
workbook.
 
Thank you for that, but still no luck. I've even tried
selecting all & deleting everything from a copy of the
original file and it still reads as 14.1MB. Is there any
way there could be some hidden data that survives a select
all and delete? Apparently the file contained images at
one point which have been deleted - could there be some
residual data left from these?
 
Back
Top