Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File grows
Good morning. I have a spreadsheet which I use for today, then "Save As" for
tomorrow, clear out all of the data that is not relevant, change the file name, and start over tomorrow. However, every time I do this, the file grows by 3 or 4 KB. After a couple of weeks, the file starts running slow, and I have to start over. The file should stay about the same size, but it doesn't. Any suggestions on what to check to see why this is happening? Thanks for any help. -- Howard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File grows
Even though you are clearing unneeded data out of cells, Excel may still be
retaining information about them (formatting, etc.) Excel also maintains a record of the last used cell on each sheet. Press Ctrl-End to see what Excel thinks is the last used cell on your worksheet. If it is not the same as the current actual last used cell, you need to reset the last used cell. You can delete the extra rows & columns Excel thinks you are using, then save/close/re-open the workbook. Debra Dalgleish's site has a couple of techniques of resetting that last used cell. http://contextures.com/xlfaqApp.html#Unused Hope this helps, Hutch "Howard" wrote: Good morning. I have a spreadsheet which I use for today, then "Save As" for tomorrow, clear out all of the data that is not relevant, change the file name, and start over tomorrow. However, every time I do this, the file grows by 3 or 4 KB. After a couple of weeks, the file starts running slow, and I have to start over. The file should stay about the same size, but it doesn't. Any suggestions on what to check to see why this is happening? Thanks for any help. -- Howard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File grows
Thanks for the help. I'll give this a try and see what happens.
Howard -- Howard "Tom Hutchins" wrote: Even though you are clearing unneeded data out of cells, Excel may still be retaining information about them (formatting, etc.) Excel also maintains a record of the last used cell on each sheet. Press Ctrl-End to see what Excel thinks is the last used cell on your worksheet. If it is not the same as the current actual last used cell, you need to reset the last used cell. You can delete the extra rows & columns Excel thinks you are using, then save/close/re-open the workbook. Debra Dalgleish's site has a couple of techniques of resetting that last used cell. http://contextures.com/xlfaqApp.html#Unused Hope this helps, Hutch "Howard" wrote: Good morning. I have a spreadsheet which I use for today, then "Save As" for tomorrow, clear out all of the data that is not relevant, change the file name, and start over tomorrow. However, every time I do this, the file grows by 3 or 4 KB. After a couple of weeks, the file starts running slow, and I have to start over. The file should stay about the same size, but it doesn't. Any suggestions on what to check to see why this is happening? Thanks for any help. -- Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one column grows as another one grows excel 2003 | Excel Discussion (Misc queries) | |||
Size of file grows | Excel Discussion (Misc queries) | |||
file size grows so big | Excel Discussion (Misc queries) | |||
Temp file grows(no-end)when Excel97 attempts to save to net-2003Se | Excel Discussion (Misc queries) | |||
File size grows enormously | Excel Programming |