Massive Excel Spreadsheet - advice please

Hi

My spreadsheet is now pushing 250k lines consisting of 20 columns of data.

Every month I have to add a new months worth of data to the sheet (approx 4k lines) and I have to refresh the last 3 months data.

So i delete the previous 3 months and then add them back in along with the new month.

This is proving tedious, Excel hangs, does not respond and crashes quite often.

I know I need to put it into some kind of access document but really not sure the best way to go about it.

Can anyone give me any advice?

Yes. The easiest way is to put it in MS Access. I believe it will be good if you post this question in the Access forum.

If your query is resolved, please mark the Thread as Solved. Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

If you found any post helpful, please rate it accordingly.