How to prevent excel from adding historical data in its memory?

[omega0010]

I have a file of about 4 MB. It is a file which uses live input of data from a trading station. With each passing day the file keeps growing in size without any visible or logical data storage (despite deleting the daily copy and paste data). Does excel have some other way to remember and keep the data other than its 100 memories for undo ? How can I prevent or reset this file which has now become a 10 MB file ? ( I do add small macros time to time but they may be very insignificant)

[tim201110]

please upload a small copy

[omega0010]

i have a file of about 4 mb. It is a file which uses live input of data from a trading station. With each passing day the file keeps growing in size without any visible or logical data storage (despite deleting the daily copy and paste data). Does excel have some other way to remember and keep the data other than its 100 memories for undo ? How can i prevent or reset this file which has now become a 10 mb file ? ( i do add small macros time to time but they may be very insignificant)i have also reduced the undo memory to 5.

"bump no response"

[omega0010]

"Bump no response"

[thisoldman]

Use Ctrl+End. This will select what Excel has determined to be the last used cell. If that last used cell is many rows or columns beyond the last cell that contains data, you have found the cause of the unwanted file size growth. A solution to be tried is to delete the unused rows and columns, save and close the file immediately, then reopen the workbook.