I'm afraid that you can't - at least not without using VB to split the file
across multiple worksheets.

I know it's not what you wanted to hear, but that's the way Excel is
designed.

Have you thought of using Access instead of Excel? There's no such
limitation there.

Alan P.

"touresaa" <touresaa@discussions.microsoft.com> wrote in message
news:2EE7381C-667A-462F-A562-7D214A26BC61@microsoft.com...
> when download large data to an excel file, it can accomodate only (65,000)
> records only, so how i can change this limitaions to have more entriy?