Huge Excel files despite small amount of data?

  Esso43 14:55 01 Nov 2004
Locked

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 2004

Bump

  keith-236785 16:49 01 Nov 2004

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 2004

I agree with paperman27.

If that doesn't work, please post back.

  Sir Radfordin 18:18 01 Nov 2004

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 2004

Full system scan done using Norton Antivirus 2002.

Nothing there, will check the undo status

  compumac 22:27 01 Nov 2004

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 2004

Why?

  Sir Radfordin 23:11 01 Nov 2004

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

  woodchip 23:17 01 Nov 2004

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 2004

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.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Inside the iMac Pro - Apple's most powerful Mac yet

iMac Pro release date, UK price & specs

Comment nettoyer Windows et optimiser son PC gratuitement ?