Does excel have a limit?

[wb]

Is there a limit to the amount of rows excel will store data in?

I download my three month history every so often and want to keep it all in the one spreadsheet. My latest one contains nearly five thousand bets (sounds massive, but if you consider that I lay the field in running for every race and also do a lot with the bot, it's not really huge). Over a year the file could build to 20,000+ rows. Is this a problem?

[mathare]

Excel has limits per sheet of 65535 rows and 256 columns but as far as I am aware there is no limit on the number of sheets a workbook can have other than the memory in your PC

[Win2Win]

Why not switch to a database if you're using that amount of data?

[wb]

Yeah, I should really. I'm not too good as using access but I suppose I'll have to learn.

[Win2Win]

Easier if you use PHP/MySQL, more flexible.

[TheOldhamWhisper]

Easier if you use PHP/MySQL, more flexible.

The saving grace for Access is that any VBA already used in Excel is easily transportable.