Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What might cause a small excel worksheet to be over 2MB?
I have a small spreadsheet that has less than 300 rows and 4 columns. For
some unknown reason the size of the file has grown to almost 2MB in size. I have another similiar excel file that is less than 400 KB in size. The file size is causing several problems in trying to edit it. |
#2
|
|||
|
|||
Hi!
Try to reset the used range: http://contextures.com/xlfaqApp.html#Unused Biff "lnflewis" wrote in message ... I have a small spreadsheet that has less than 300 rows and 4 columns. For some unknown reason the size of the file has grown to almost 2MB in size. I have another similiar excel file that is less than 400 KB in size. The file size is causing several problems in trying to edit it. |
#3
|
|||
|
|||
Do you have any pictures/objects on any of the worksheets?
Select a worksheet edit|goto special|check Objects Then you can tab between them--to see if there are more than you expect. lnflewis wrote: I have a small spreadsheet that has less than 300 rows and 4 columns. For some unknown reason the size of the file has grown to almost 2MB in size. I have another similiar excel file that is less than 400 KB in size. The file size is causing several problems in trying to edit it. -- Dave Peterson |
#4
|
|||
|
|||
go to the fifth column and select. hit shift+ctrl+right arrow. right click and delete. go to first blank row of data. hit shift+ctrl+down arrow. right click and delete. save the file and it should be much smaller. i've had this issue many times with excel where if you just hit delete on your keyboard, it doesnt really delete the memory used unless you delete the actual cell and that frees up the memory. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=474651 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) |