M
marsulein
May I know is there a maximum number of sheets for Excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Default maximum number in a new workbook is 255.
You can add more if you have the resources.
Gord Dibben MS Excel MVP
You can add more if you have the resources.
Gord Dibben MS Excel MVP
M
marsulein
Gord said:Default maximum number in a new workbook is 255.
You can add more if you have the resources.
Gord Dibben MS Excel MVP
Thanx for the reply. What do you mean when you said if i have th
resources
D
Dave Peterson
If your pc has the horsepower (memory) to support lots and lots of sheets.
But as a practical matter, I would think that you would confuse users once you
hit a big enough number of sheets.
But as a practical matter, I would think that you would confuse users once you
hit a big enough number of sheets.
D
dbahooker
1 sheet in Excel is TOO MANY.
Excel shouldn't be used as a database.
Excel dorks are the reason that we have identity theft. Data shouldn't
be carted around without security.
-Aaron
ADP Nationalist
Excel shouldn't be used as a database.
Excel dorks are the reason that we have identity theft. Data shouldn't
be carted around without security.
-Aaron
ADP Nationalist
H
Harlan Grove
(e-mail address removed) wrote...
....
Where did the OP mention 'database'?
....
....Excel shouldn't be used as a database.
Where did the OP mention 'database'?
G
greaseman
1 sheet in Excel is TOO MANY.
Aaron, you mental midget, 1 sheet is probably too much for YOU, but not
those of us who know how to use Excel.
Excel shouldn't be used as a database.
And again, Aaron, you mental midget, Excel is not a database. Why do
you keep telling people it's not a database. Don't you ever tire of
stating the obvious, or has it taken you this long to figure out that
Excel is not and was not ever designed to be a database??? You
intellectually challenged dork!
Excel dorks are the reason that we have identity theft. Data shouldn't
be carted around without security.
Huh?? Where in this thread is anything mentioned about identity theft?
I think the only theft that has occurred here is your remaining 3 brain
cells have disappeared. Grow up and stick to the subject of a thread,
you mental midget!!
A
aaron.kempf
what he's keeping 5,000 WORKSHEETS of unrelated data?
no he probbaly has a worksheet for each employee or something stupid
USE A DATABASE
no he probbaly has a worksheet for each employee or something stupid
USE A DATABASE
A
aaron.kempf
if Excel ISN'T A DATABASE
then STOP USING IT AS ONE
Excel dorks use Excel for data entry ALL the time.
It's laughable.
Can't even enforce datatypes lol
Or if you can; copy / paste gets around it.
-Aaron
then STOP USING IT AS ONE
Excel dorks use Excel for data entry ALL the time.
It's laughable.
Can't even enforce datatypes lol
Or if you can; copy / paste gets around it.
-Aaron
H
Harlan Grove
(e-mail address removed) wrote...
Where'd the OP mention 5000?
Or just something you can't understand, so almost anything.
what he's keeping 5,000 WORKSHEETS of unrelated data?
Where'd the OP mention 5000?
no he probbaly has a worksheet for each employee or something stupid
Or just something you can't understand, so almost anything.
H
Harlan Grove
(e-mail address removed) wrote...
Where did the OP mention intended use? Couldn't be that using Excel as
a database is the only thing you can do with Excel, is it?
Which is it, can't or can?
It's can, though you don't know how.
Copy & paste bypasses data validation, but that's a toy feature. There
are better ways to accomplish this. Have you learned any yet?
....if Excel ISN'T A DATABASE
then STOP USING IT AS ONE
Where did the OP mention intended use? Couldn't be that using Excel as
a database is the only thing you can do with Excel, is it?
Can't even enforce datatypes lol
Or if you can; copy / paste gets around it.
Which is it, can't or can?
It's can, though you don't know how.
Copy & paste bypasses data validation, but that's a toy feature. There
are better ways to accomplish this. Have you learned any yet?
A
aaron.kempf
what's the difference between FIVE and FIVE THOUSAND?
FIVE worksheets is too many.
Man:
Would you sleep with me for $50?
Woman:
Of Course Not.
Man:
How about $50,000
Woman:
Of Course I would.
Man:
Ok well $50 it is.
Woman:
What do you take me for, a whore?
Man:
We've already established that you are now we're just haggling over
price.
I SEE NO DIFFERENCE BETWEEN 5 WORKSHEETS AND 5,000.
_ANY_ NUMBER OF WORKSHEETS IS DISGUSTING, REPULSIVE AND A WASTE OF
TIME.
Dirty Excel WHORE
-Aaron
FIVE worksheets is too many.
Man:
Would you sleep with me for $50?
Woman:
Of Course Not.
Man:
How about $50,000
Woman:
Of Course I would.
Man:
Ok well $50 it is.
Woman:
What do you take me for, a whore?
Man:
We've already established that you are now we're just haggling over
price.
I SEE NO DIFFERENCE BETWEEN 5 WORKSHEETS AND 5,000.
_ANY_ NUMBER OF WORKSHEETS IS DISGUSTING, REPULSIVE AND A WASTE OF
TIME.
Dirty Excel WHORE
-Aaron
H
Harlan Grove
(e-mail address removed) wrote...
No doubt just one is beyond your abilities.
....what's the difference between FIVE and FIVE THOUSAND? ....
From the point of view of your mathematical, er, competence, they're indistinguishable.
FIVE worksheets is too many.
No doubt just one is beyond your abilities.
A
aaron.kempf
Harlan;
I could give a rats ass.. I was building Excel solutions while you were
still fucking your mother.
I've grown some balls since then and realized how nasty that is.
I'm talking about Excel being nasty; not you screwing your mother.
-Aaron
I could give a rats ass.. I was building Excel solutions while you were
still fucking your mother.
I've grown some balls since then and realized how nasty that is.
I'm talking about Excel being nasty; not you screwing your mother.
-Aaron
H
Harlan Grove
(e-mail address removed) wrote...
No doubt it's all you have to give. How was he?
Solving what? The answer to dividing by zero? The answer to how many
personnel mistakes Microsoft had to make before they were able to
figure out you were a doozy? What was wrong? Your mouth too much larger
than your skillz?
The few times you've posted any suggestions for how to do things in
Excel, you've only succeeded in demonstrating you know next to nothing,
a few poorly conceived and poorly implemented attempts that I and
others have improved upon.
You know squat about Excel. But go on and try to prove you do. The
evidence so far shows you're not even worth an interview much less an
entry level job.
I could give a rats ass.. . . .
No doubt it's all you have to give. How was he?
I was building Excel solutions . . .
Solving what? The answer to dividing by zero? The answer to how many
personnel mistakes Microsoft had to make before they were able to
figure out you were a doozy? What was wrong? Your mouth too much larger
than your skillz?
The few times you've posted any suggestions for how to do things in
Excel, you've only succeeded in demonstrating you know next to nothing,
a few poorly conceived and poorly implemented attempts that I and
others have improved upon.
You know squat about Excel. But go on and try to prove you do. The
evidence so far shows you're not even worth an interview much less an
entry level job.
J
Jay Petrulis
what he's keeping 5,000 WORKSHEETS of unrelated data?
no he probbaly has a worksheet for each employee or something stupid
USE A DATABASE
If it is unrelated data, what benefit would it be to use a database?
Lemon juice.
A
aaron.kempf
Harlan;
you're wrong. I do know how to waste my time in Excel just as much as
the next idiot.
But the point remains-- I don't have to KNOW how to GIVE an abortion in
order to be opposed to it.
I do know Excel-- better than I'd like to admit. I've worked on
million dollar spreadsheets and auditing formuals... I've consumed more
spreadsheets than I'd like to admit.
And from what I've seen in it.. 95% of the time that people use Excel
they should be using Crystal Reports or Access.
Excel isn't strong enough for:
a) data entry
b) filtering - can you exclude multiple items? how about you show me
how to EXCLUDE everybody with the last name Johnson in Excel. In
Access? It's a simple right-click 'Exclude'
c) sorting - if you kids want to sort the data in 2 different ways you
have two copies of the data. RIGHT? that's just friggin ridiclous
d) data type validation - excel doesn't have it and it's impossible to
enforce
e) complex input masks - excel doesn't have it. it's EASY in Access...
WITHOUT PROGRAMMING
f) print out 4 different worksheets in Excel without doing it by hand
or writing code. ITS EASY IN ACCESS.
Excel just doesn't have 1/10th of the functionality of a simple desktop
database system like Excel.
It NEEDS real ETL type cleansing.. because you idiots use it for that.
Maybe they just need to make a version of Excel; that is built for
database professionals.
I mean seriously here.
Excel is for babies. It doesn't do simple datatype validation.
It can't enforce referential integrity.
It can't import and export data.
But you dipshits use it to import and export data.
Excel isn't a tool it is a disease.
-Aaron
-Aaron
you're wrong. I do know how to waste my time in Excel just as much as
the next idiot.
But the point remains-- I don't have to KNOW how to GIVE an abortion in
order to be opposed to it.
I do know Excel-- better than I'd like to admit. I've worked on
million dollar spreadsheets and auditing formuals... I've consumed more
spreadsheets than I'd like to admit.
And from what I've seen in it.. 95% of the time that people use Excel
they should be using Crystal Reports or Access.
Excel isn't strong enough for:
a) data entry
b) filtering - can you exclude multiple items? how about you show me
how to EXCLUDE everybody with the last name Johnson in Excel. In
Access? It's a simple right-click 'Exclude'
c) sorting - if you kids want to sort the data in 2 different ways you
have two copies of the data. RIGHT? that's just friggin ridiclous
d) data type validation - excel doesn't have it and it's impossible to
enforce
e) complex input masks - excel doesn't have it. it's EASY in Access...
WITHOUT PROGRAMMING
f) print out 4 different worksheets in Excel without doing it by hand
or writing code. ITS EASY IN ACCESS.
Excel just doesn't have 1/10th of the functionality of a simple desktop
database system like Excel.
It NEEDS real ETL type cleansing.. because you idiots use it for that.
Maybe they just need to make a version of Excel; that is built for
database professionals.
I mean seriously here.
Excel is for babies. It doesn't do simple datatype validation.
It can't enforce referential integrity.
It can't import and export data.
But you dipshits use it to import and export data.
Excel isn't a tool it is a disease.
-Aaron
-Aaron
H
Harlan Grove
(e-mail address removed) wrote...
An admission: you know how to use Excel like an idiot. Just what I
said.
Progress!
You have to know and comminicate the details in order to change other
people's minds. That is, if you wanted to influence anyone else. You,
however, would seem to be content just to throw firebombs into clinics.
It's what people incapable or rational discussion do.
And when you were done it was a $0.02 spreadsheet? Or am I understating
the magnitude of your accomplishments?
Shame no understanding or any competence came out of all this time
spent using spreadsheets.
That may be what you've seen. Spreadsheets are often misused for
creating reports.
Autofilter?
Choose Custom from the autofilter dropdown, choose 'does not equal' or
'does not contain' in the dropdown on the left, and enter Johnson in
the entry field to the right of the dropdown. Press [Enter] or click
the OK button.
Granted not as simple as in Access.
Me, I've never found any need for different sorts. Now if you mean that
you have different views of the same table with different sorts in each
view, then either your database is performing a sort every time you
open views sorted differently than the actual table, in which case
there's a space vs execution time trade-off you're ignoring (or of
which you're ignorant), or your database is maintaining an index for
each different view, in which case the storage savings isn't as great
as you imagine and there's still additional processing involved in
using such an index.
It requires VBA if you mean at time of entry. Otherwise, it's pretty
simple (but way beyond your abilities) to ensure that errors are
propagated and diagnostic messages are displayed when there are invalid
entries.
Granted.
As a counter, tabular data in PDF files can often be copied in Acrobat
[Reader] and pasted into Excel. It make require running Data > Text to
Columns to make it a usable table in Excel, but the whole thing's a
3-step process. How would you manage that with Access?
You mean select the 4 worksheets' tabs and press [Ctrl]+P? So for you
that's REALLY DIFFICULT?
Are you really this ignorant how to use Excel? I can see why you don't
want to provide any details. It'd prove how little you know.
you're wrong. I do know how to waste my time in Excel just as much as
the next idiot.
An admission: you know how to use Excel like an idiot. Just what I
said.
Progress!
....But the point remains-- I don't have to KNOW how to GIVE an abortion in
order to be opposed to it.
You have to know and comminicate the details in order to change other
people's minds. That is, if you wanted to influence anyone else. You,
however, would seem to be content just to throw firebombs into clinics.
It's what people incapable or rational discussion do.
....I do know Excel-- better than I'd like to admit. I've worked on
million dollar spreadsheets and auditing formuals... I've consumed more
spreadsheets than I'd like to admit.
And when you were done it was a $0.02 spreadsheet? Or am I understating
the magnitude of your accomplishments?
Shame no understanding or any competence came out of all this time
spent using spreadsheets.
....And from what I've seen in it.. 95% of the time that people use Excel
they should be using Crystal Reports or Access.
That may be what you've seen. Spreadsheets are often misused for
creating reports.
b) filtering - can you exclude multiple items? how about you show me
how to EXCLUDE everybody with the last name Johnson in Excel. In
Access? It's a simple right-click 'Exclude'
Autofilter?
Choose Custom from the autofilter dropdown, choose 'does not equal' or
'does not contain' in the dropdown on the left, and enter Johnson in
the entry field to the right of the dropdown. Press [Enter] or click
the OK button.
Granted not as simple as in Access.
c) sorting - if you kids want to sort the data in 2 different ways you
have two copies of the data. RIGHT? that's just friggin ridiclous
Me, I've never found any need for different sorts. Now if you mean that
you have different views of the same table with different sorts in each
view, then either your database is performing a sort every time you
open views sorted differently than the actual table, in which case
there's a space vs execution time trade-off you're ignoring (or of
which you're ignorant), or your database is maintaining an index for
each different view, in which case the storage savings isn't as great
as you imagine and there's still additional processing involved in
using such an index.
d) data type validation - excel doesn't have it and it's impossible to
enforce
It requires VBA if you mean at time of entry. Otherwise, it's pretty
simple (but way beyond your abilities) to ensure that errors are
propagated and diagnostic messages are displayed when there are invalid
entries.
e) complex input masks - excel doesn't have it. it's EASY in Access...
WITHOUT PROGRAMMING
Granted.
As a counter, tabular data in PDF files can often be copied in Acrobat
[Reader] and pasted into Excel. It make require running Data > Text to
Columns to make it a usable table in Excel, but the whole thing's a
3-step process. How would you manage that with Access?
f) print out 4 different worksheets in Excel without doing it by hand
or writing code. ITS EASY IN ACCESS.
You mean select the 4 worksheets' tabs and press [Ctrl]+P? So for you
that's REALLY DIFFICULT?
Are you really this ignorant how to use Excel? I can see why you don't
want to provide any details. It'd prove how little you know.
J
Jay Petrulis
Uh huh. Lemon juice.I do know Excel-- better than I'd like to admit. I've worked on
million dollar spreadsheets and auditing formuals... I've consumed more
spreadsheets than I'd like to admit.
Grape juice.And from what I've seen in it.. 95% of the time that people use Excel
they should be using Crystal Reports or Access.
Excel isn't strong enough for:
b) filtering - can you exclude multiple items? how about you show me
how to EXCLUDE everybody with the last name Johnson in Excel. In
Access? It's a simple right-click 'Exclude'
Look at AutoFilter. Not a right-click event, but only a few steps,
thereby overtaxing one Aaron Kempf. Pomegranate juice.
c) sorting - if you kids want to sort the data in 2 different ways you
have two copies of the data. RIGHT? that's just friggin ridiclous
Spare us the condescension over sorting until you sort the fields in a
record in ascending order, as you claimed to be able to do easily.
I will excuse the typo which makes your statement meaningless, and if IExcel just doesn't have 1/10th of the functionality of a simple desktop
database system like Excel.
infer that you meant to write Access -- lime juice.
Thereby excluding you from the target market for this version.Maybe they just need to make a version of Excel; that is built for
database professionals.
Pineapple juice.
Got it. I thought you were joking before.I mean seriously here.
Answered numerous times by Harlan.Excel is for babies. It doesn't do simple datatype validation.
It can't enforce referential integrity.
How much juice are you wearing, a 55-gallon drum?It can't import and export data.
But you dipshits use it to import and export data.
Lemon juice-Aaron
-Aaron
Lemon juice
D
dbahooker
ok so show me people that don't have the last name Johnson or Jones.
2 clicks in Access.
Right-click EXCLUDE followed by Right-click EXCLUDE
2 clicks in Access.
Right-click EXCLUDE followed by Right-click EXCLUDE
Harlan said:(e-mail address removed) wrote...you're wrong. I do know how to waste my time in Excel just as much as
the next idiot.
An admission: you know how to use Excel like an idiot. Just what I
said.
Progress!
...But the point remains-- I don't have to KNOW how to GIVE an abortion in
order to be opposed to it.
You have to know and comminicate the details in order to change other
people's minds. That is, if you wanted to influence anyone else. You,
however, would seem to be content just to throw firebombs into clinics.
It's what people incapable or rational discussion do.
...I do know Excel-- better than I'd like to admit. I've worked on
million dollar spreadsheets and auditing formuals... I've consumed more
spreadsheets than I'd like to admit.
And when you were done it was a $0.02 spreadsheet? Or am I understating
the magnitude of your accomplishments?
Shame no understanding or any competence came out of all this time
spent using spreadsheets.
...And from what I've seen in it.. 95% of the time that people use Excel
they should be using Crystal Reports or Access.
That may be what you've seen. Spreadsheets are often misused for
creating reports.
b) filtering - can you exclude multiple items? how about you show me
how to EXCLUDE everybody with the last name Johnson in Excel. In
Access? It's a simple right-click 'Exclude'
Autofilter?
Choose Custom from the autofilter dropdown, choose 'does not equal' or
'does not contain' in the dropdown on the left, and enter Johnson in
the entry field to the right of the dropdown. Press [Enter] or click
the OK button.
Granted not as simple as in Access.
c) sorting - if you kids want to sort the data in 2 different ways you
have two copies of the data. RIGHT? that's just friggin ridiclous
Me, I've never found any need for different sorts. Now if you mean that
you have different views of the same table with different sorts in each
view, then either your database is performing a sort every time you
open views sorted differently than the actual table, in which case
there's a space vs execution time trade-off you're ignoring (or of
which you're ignorant), or your database is maintaining an index for
each different view, in which case the storage savings isn't as great
as you imagine and there's still additional processing involved in
using such an index.
d) data type validation - excel doesn't have it and it's impossible to
enforce
It requires VBA if you mean at time of entry. Otherwise, it's pretty
simple (but way beyond your abilities) to ensure that errors are
propagated and diagnostic messages are displayed when there are invalid
entries.
e) complex input masks - excel doesn't have it. it's EASY in Access...
WITHOUT PROGRAMMING
Granted.
As a counter, tabular data in PDF files can often be copied in Acrobat
[Reader] and pasted into Excel. It make require running Data > Text to
Columns to make it a usable table in Excel, but the whole thing's a
3-step process. How would you manage that with Access?
f) print out 4 different worksheets in Excel without doing it by hand
or writing code. ITS EASY IN ACCESS.
You mean select the 4 worksheets' tabs and press [Ctrl]+P? So for you
that's REALLY DIFFICULT?
Are you really this ignorant how to use Excel? I can see why you don't
want to provide any details. It'd prove how little you know.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.