So far as Excel is concerned, the file size is irrelevant. What matters is the number of lines. Unless the number of lines exceeds 1,048,576, there is no need to split it across multiple sheets; indeed it is generally better not to split the data - splitting makes it harder to process later.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|