By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

Number of records found

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a

"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?
Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

P: n/a
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.
Nov 12 '05 #4

P: n/a

"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.
Nov 12 '05 #5

P: n/a
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!
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.