Number of records found

[Les Stout]

Good day,

I am not sure if this is the right forum for this question, but would
appreciate any help.

I have a spread sheet with a lot of rowws in, about 5000 and before i
deleted a lot i had 9000.
The question is that when i filter by a certain criteria, i get a
message at the very bottom of the spreadsheet saying; "500 of 9540
records found".
Can a person change this or is this something that Excel does itself ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Robert]

"Les Stout" <le*******@bmw.co.za> wrote in message
news:40*********************@news.frii.net...

Good day,

I am not sure if this is the right forum for this question, but would
appreciate any help.

I have a spread sheet with a lot of rowws in, about 5000 and before i
deleted a lot i had 9000.
The question is that when i filter by a certain criteria, i get a
message at the very bottom of the spreadsheet saying; "500 of 9540
records found".
Can a person change this or is this something that Excel does itself ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

This is an Access forum, not an Excel forum, so you're fear is correct. Why
do you have so many rows in your spreadsheet?

[Les Stout]

Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Trevor Best]

Les Stout wrote:

Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Excel is possibly the single worst POS for handling data there ever was,
great spread sheet, but really crap for data. even if you get the number
of rows right you'll bound to end up with data type errors. IME it's the
worst thing to use as an intermediary data transfer program. Consider
ASCII files (CSV, fixed length.

[Robert]

"Les Stout" <le*******@bmw.co.za> wrote in message
news:40*********************@news.frii.net...

Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Well, you need to explore other possibilities. Good luck.

[Tempy]

Thanks for the help, much appreciated

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!