471,073 Members | 1,404 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Number of records found

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
5 1474

"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
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
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

"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
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.

Similar topics

4 posts views Thread by amywolfie | last post: by
2 posts views Thread by chris vettese | last post: by
2 posts views Thread by Mike N. | last post: by
4 posts views Thread by Greg Strong | last post: by
4 posts views Thread by Tim T | last post: by
29 posts views Thread by james | last post: by
19 posts views Thread by eric.nave | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.