most recent 30 from superuser.com 2010-03-11T14:13:57Z http://superuser.com/feeds/question/63119 http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://superuser.com/questions/63119/excel-file-suddenly-35mb 1 Emre http://superuser.com/users/0 2009-10-30T14:50:49Z 2009-10-31T03:37:45Z

<p>What can cause an 945KB Excel file to grow to 35MB without any warnings. Tips: 1-)There are table formattings that converted ranges to Tables and I converted them back to Range. Can it be that? 2-) Macros crashed Excel several times and file recovery pane appeared but I always choose close without re-saving anything.</p> <p>Thanks in advance</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63139#63139 4 Botond Balázs http://superuser.com/users/16048 2009-10-30T15:25:26Z 2009-10-30T15:25:26Z

<p>Last time I experienced this, the problem was that someone set the background of thousands of cells to white. It seems that Excel stored these separately. Try selecting all cells and removing formatting.</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63150#63150 4 kamleshrao http://superuser.com/users/4385 2009-10-30T15:38:40Z 2009-10-30T15:38:40Z

<p>I too faced such problems. If you zip this 35MB Excel, the zip file will be very small. Am I right?</p> <p>Try this Workaround - Try copying and pasting the range of required cells into New Excel File and check the new file size.</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63185#63185 1 Insomnic http://superuser.com/users/8743 2009-10-30T16:19:26Z 2009-10-30T16:19:26Z

<p>It would seem the most likely cause is the addition of cells either by formatting or bad data input. An easy way to see this is by looking at the scroll bars. If the drag bar is extremely skinnny and you are only using 100 rows (or A-G columns) then you have a lot of extra rows/columns being remembered. Copy/pasting the required data into a new workbook will fix this but may cause problems depending on the type of data involved. A way to remove the hose unnecessary cells is by dragging the scroll bar to the end (don't use the scroll wheel) and then selecting and deleting the "extra" rows or columns.</p> <p>Check the reviewing options as well. If the document has been passed around a few times and markups have been applied with out a full accept/deny of those changes, the document can get very large. This is more common with PowerPoint and Word but can affect Excel.</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63196#63196 0 joe http://superuser.com/users/3630 2009-10-30T16:39:12Z 2009-10-30T16:39:12Z

<p>it may you enable the versioning feature of your document and each every save it will be create new version . that may be reason for suddenly increase size of file .</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63367#63367 0 shoover http://superuser.com/users/16161 2009-10-30T23:37:34Z 2009-10-30T23:37:34Z

<p>If you have turned on workbook sharing so that multiple users can update the document simultaneously, then the default is to keep a change history for 30 days. This can cause the document to grow ridiculously large pretty quickly.</p>

http://superuser.com/questions/63119/excel-file-suddenly-35mb/63433#63433 0 Emre http://superuser.com/users/16181 2009-10-31T03:37:45Z 2009-10-31T03:37:45Z

<p>I found out by trial and error. Started copying sheets to a new Book and saw that one sheet full with data, was formatted by me, selecting the excel 2007 option "format as table" and even converted back to range (which took considerably long)I think the coloring of cells cause this... I wonder who have done this at microsoft. cruel stuff!</p>