limit of ligns

Julien Lopez

Hi

is there a limit of ligns in a grid sheet?

i would like to create a new one that could potentially reach more than 100 000 ligns in a year ! but very basic and no big formulas… is it too much?

thank you

VBAGuru

The limit is 20,000 lines
400 columns
But total cells cannot be more than 500,000 with combination of rows and columns

VBAGuru

The limit is 20,000 lines
400 columns
But total cells cannot be more than 500,000 with combination of rows and columns

Julien Lopez

@VBAGuru thank you!