Huge Excel files despite small amount of data?

  Esso43 14:55 01 Nov 04

Can anybody shed some light on this?

A collegue has been having crashes with his laptop and when he re-opens the Excel workbook it is growing in size to the point he has a 2114kb model with approx 60 columns and 30 rows with not much else?

Any pointers welcome.

  Esso43 16:15 01 Nov 04


  keith-236785 16:49 01 Nov 04

has your friend virus checked the laptop, also check for trojans and spyware.

if in boubt, copy the data to a new book and delete the present one to rule out any problems with the file.

also, wait for VoG (excel expert) to jump in and maybe shed some light

  VoG II 17:34 01 Nov 04

I agree with paperman27.

If that doesn't work, please post back.

  Sir Radfordin 18:18 01 Nov 04

My guess would be that Excel is saving lots of 'undo' data or versions of the file to use for recovery. As paperman27 suggestes copying the data to a new workbook may rule this out. You could also get your collegue to do a "Save As" and see if the new file is smaller than the original

  Esso43 20:16 01 Nov 04

Full system scan done using Norton Antivirus 2002.

Nothing there, will check the undo status

  compumac 22:27 01 Nov 04

A spreadsheet is more economical sizewise if the rows are greater than the columns. In your case you have 60 columns but only 30 rows. I agree that if that is not the casue of the problem copy and paste into a completely new workbook.

  VoG II 22:39 01 Nov 04


  Sir Radfordin 23:11 01 Nov 04

surely you have the same data stored in the file so there would be no difference in size??

  woodchip 23:17 01 Nov 04

It's one of the Problem's with MS Office it also happens in word. Have you loaded all the MS patches for Office. It was more a Problem with older versions of Office i.e. 95 and 97

  Forum Editor 23:46 01 Nov 04

your file may be corrupted.

1. Right click on a sheet name tab and select "Select all sheets".

2. Right click again and select "Move or copy" Check the 'Create a copy' option then select 'New Book' and click OK.

3. Save the new Workbook as any new name and check its file size via File/Properties/General. With luck you'll have resolved the problem.

If there's no big difference, delete one sheet at a time (in the new workbook) and then save, each time checking the file size to see if there has been a disproportionate reduction. If there has, that particular sheet may have been corrupt, in which case go back to the the original Workbook and copy the entire contents of the possibly corrupt Worksheet. Return to the new Workbook, insert a new Worksheet and paste the copied data into it. If this doesn't work you can try deleting a few rows at a time (Saving each time) until you find the offending row or rows.

It may be a bit of a pain to do, but it does tend to isolate the problem.

This thread is now locked and can not be replied to.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Switch price…

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…