Maximum Number of Sheets
marsulein
May I know is there a maximum number of sheets for Excel?
--
marsulein
------------------------------------------------------------------------
marsulein's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16064
View this thread: http://www.excelforum.com/showthread.php?threadid=567732
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
marsulein
Thanx for the reply. What do you mean when you said if i have the
resources?
Dave Peterson
But as a practical matter, I would think that you would confuse users once you
hit a big enough number of sheets.
--
Dave Peterson
dbah...@hotmail.com
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
Harlan Grove
...
>Excel shouldn't be used as a database.
Where did the OP mention 'database'?
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!!
--
greaseman
------------------------------------------------------------------------
greaseman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28808
aaron...@gmail.com
no he probbaly has a worksheet for each employee or something stupid
USE A DATABASE
aaron...@gmail.com
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
Harlan Grove
>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.
Harlan Grove
>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?
aaron...@gmail.com
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
Harlan Grove
>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.
aaron...@gmail.com
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
Harlan Grove
>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.
Jay Petrulis
aaron...@gmail.com wrote:
> 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.
aaron...@gmail.com
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
Harlan Grove
>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.
Jay Petrulis
aaron...@gmail.com wrote:
> 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.
>
Grape juice.
> 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.
> Excel just doesn't have 1/10th of the functionality of a simple desktop
> database system like Excel.
>
I will excuse the typo which makes your statement meaningless, and if I
infer that you meant to write Access -- lime juice.
> Maybe they just need to make a version of Excel; that is built for
> database professionals.
>
Thereby excluding you from the target market for this version.
Pineapple juice.
> I mean seriously here.
>
Got it. I thought you were joking before.
> Excel is for babies. It doesn't do simple datatype validation.
> It can't enforce referential integrity.
>
Answered numerous times by Harlan.
> It can't import and export data.
>
> But you dipshits use it to import and export data.
>
How much juice are you wearing, a 55-gallon drum?
>
> -Aaron
>
> -Aaron
>
Lemon juice
Lemon juice
dbah...@hotmail.com
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
Jay Petrulis
dbah...@hotmail.com wrote:
> 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
>
>
Autofilter>Custom>DoesNotEqual (Johnson) AND DoesNotEqual (Jones)>OK.
Again, not as easy as in Access, but not too terribly difficult,
either. Additional exclusions would require another approach (advanced
Filter, VBA)
How about this one for you...multiply two matrices together.
Harlan Grove
>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
FTHOI, how would you EXCLUDE all names containing Smith, so not only
Smith itself, but also Smithson, Barry-Smith, Blacksmith (case
insensitive, too)? In Excel, choose Custom from the autofilter
dropdown, select 'does not contain' and enter Smith (or smith). How
would you manage that in Access without a query or having to locate all
matching names manually in order to exclude them?
dbah...@hotmail.com
a) have one matrix.
b) keep it secure
Excel is inherently an insecure solution.
Idiots like you is why Identity Thieves have a heyday-- because idiots
like you keep hundreds of copies of the same data lying around.
-Aaron
Harlan Grove
>how about this one:
>
>a) have one matrix.
>b) keep it secure
And if you're so incompetent you can't figure out how to do anything
with that matrix, then it's even more secure still.
So much for your definition of 'security'.
Problem is that matrices like representations of stress tensors are
varying continuously. There's no ONE matrix. In realistic simulations,
there could be several BILLION different matrices. When they need to be
transformed by multiplying against possibly several billion other
matrices, would you be trying to cache the several quadrillion possible
results in a database?
You have no clue how anyone would use a matrix, do you?
aaron...@gmail.com
big friggin deal.
i can generate matrices with cartesianing.. any day i want
Jay Petrulis
aaron...@gmail.com wrote:
> its' multidimensional data.
>
> big friggin deal.
>
> i can generate matrices with cartesianing.. any day i want
>
Unskilled, Unaware, Incompetent...Lemon Juice!
Harlan Grove
>its' multidimensional data.
...
>i can generate matrices with cartesianing.. any day i want
Possibly, but can you perform any matrix arithmetic operations with
them?
Lets assume you have 2 matrices in normalized form,
Matrix A
Row__Col__Val
_1_____1___1
_1_____2__ -2
_1_____3___3
_2_____1__ -4
_2_____2___5
_2_____3__ -6
Matrix B
Row__Col_____Val
_1_____1_______1
_1_____2______20
_1_____3_____300
_1_____4____4000
_2_____1_______5
_2_____2______60
_2_____3_____700
_2_____4____8000
_3_____1___10000
_3_____2____2000
_3_____3_____300
_3_____4______40
Then produce matrix C = A * B (note that matrix multiplication isn't
commutative).
Matrix C
Row____Col____Val
_1_______1__29991
_1_______2___5900
_1_______3___ -470
_1_______4_ -11880
_2_______1_ -59979
_2_______2_ -11780
_2_______3___1580
_2_______4__23760
You have to ensure that matrices A and B are matrices, i.e., there are
the same number of Col values for each Row value and vice versa, and
both Row and Col values are sequential integers beginning with 1. Next
you have to ensure that they conform, meansing the number of columns in
A must equal the number of rows in B. Finally you have to calculate the
values in C. For example, C's Row 1 Col 1 Val is given by
1 * 1 + -2 * 5 + 3 * 10000
That should be enough for you to write an inner join query involving
SUM(A.Val * B.Val). You may even be able to write one query that could
handle any pair of conforming matrices. Checking whether arbitrary
tables were matrices, and whether two matrices in specified order
conform would be a bit harder. And even when you've done this, all
you'd have is several queries that perform the same task as a SINGLE
Excel function call.
Databases are simpler for this?
Jay Petrulis
Harlan, have you not followed the "conversations" in various Aaron
Kempf threads today? From the sorting thread, you should know that
basically all the data points should be in a single column/field.
Sheesh, putting a matrix in a matrix! What crazy talk.
Databases are simpler for everything. Do you discount what Aaron says?
aaron...@gmail.com
how do you enforce datatypes in Excel?
so that disabling macros and copy / paste still follows these rules??
please tell me buddy; I'm dying to here.
In access / SQL; it's SIMPLE. Just choose a datatype. DATE for
example.
you broken idiot monkeys keep on using Excel for data entry
you get stuck with mountains of unclean data.. and then you have to
bring in a real programmer to sort it out.
Why dont you kids NEED real dataType validation?
I mean I know you guys use Excel for data entry..
you keep your little checklists and to-do lists and all that crap it
just makes me sick
-Aaron
Jay Petrulis
aaron...@gmail.com wrote:
> seriously Jay
>
> how do you enforce datatypes in Excel?
>
> so that disabling macros and copy / paste still follows these rules??
>
> please tell me buddy; I'm dying to here.
>
Harlan has offered workarounds for after-the-fact data validation.
Nobody disagrees with you that databases do this much better than
spreadsheets.
seriously Aaron
How do you invert a matrix in a database? Multiply two matrices?
How do you create a loan amortization schedule?
Please tell me.
> In access / SQL; it's SIMPLE. Just choose a datatype. DATE for
> example.
>
In Excel, I would use the native MMULT function to multiply the
matrices, nesting a TRANSPOSE call if one needed to be reshaped (not
sure that reshaped is the proper term, but you don't have a clue what I
am saying, anyway).
It's SIMPLE. Just select the two matrices as arguments to the
function.
> you broken idiot monkeys keep on using Excel for data entry
> you get stuck with mountains of unclean data.. and then you have to
> bring in a real programmer to sort it out.
>
You live in a castle in the sky, don't you? Define "mountains of
unclean data." How much is truly unworkable? Do you consider yourself
a real programmer (hint: think lemon juice).
> Why dont you kids NEED real dataType validation?
>
> I mean I know you guys use Excel for data entry..
>
> you keep your little checklists and to-do lists and all that crap it
> just makes me sick
>
> -Aaron
>
Why do you care so much about what spreadsheet users do? In my case, I
will never need to hire you to come in and clean up, so you can take
your crusade elsewhere if you think your newsgroup terrorism will
impact what I do. This back and forth is fun, but it's getting boring
because you don't troll very creatively.
I cannot imagine a single sane person, no matter how bad their data is,
who will hire you. I cannot fathom that it will ever get that bad.
You *have* to be a last resort.
aaron...@gmail.com
Macros are a security risk in Excel.. but not in ACCESS asshole
For starters, you can't email Access Apps around.
-Aaron
Harlan Grove
>Macros?
>
>Macros are a security risk in Excel.. but not in ACCESS asshole
>
>For starters, you can't email Access Apps around.
ADPs and MDBs can't contain VBA modules?
MDBs (and even ADB files as interfaces to database servers) can't be
attached to e-mails?
Do you ever understand what you're talking about?
aaron...@gmail.com
BUT THEY'RE NOT AS DANGEROUS AS EXCEL VBA.
I've posted several articles in the past few months that state WHY this
is true. Effectively, Excel and Word are designed to keep most of the
macros in a common file-- like normal.dot for example. Access is more
secure because it doesn't do this. Library databases are a similiar
discussion.. and of course you can use multiple library databases... or
a DLL.
But the bottom line is that if I want to share business logic between
multiple apps? I keep it in a database.
And for the record?? the docmd object is why -- single handedly that
Access is 100 times more powerful than Excel.
in most popular email systems; MDB and ADP are prohibited extensions.
It _SHOULD_ be the same way with XLS and all other XLHELL extensions.
Even though ADP are tiny ass files-- there is no point in emailing them
around.
Do I understand what I'm talking about?? YES I DO.
Harlan Grove
>ADP and MDB support VBA modules.
>BUT THEY'RE NOT AS DANGEROUS AS EXCEL VBA.
>
>I've posted several articles in the past few months that state WHY this
>is true. Effectively, Excel and Word are designed to keep most of the
>macros in a common file-- like normal.dot for example. Access is more
>secure because it doesn't do this. Library databases are a similiar
>discussion.. and of course you can use multiple library databases... or
>a DLL.
In other words, there's no Access equivalent to Word's Normal.dot or
Excel's Personal.xls. OK, that may be true. It's also the case that
Access has no Open event similar to that of Excel. That would reduce
the frequency of running malicious code. However, once running, Access
VBA could do all the nasty things Excel VBA could.
>in most popular email systems; MDB and ADP are prohibited extensions.
...
Name 'em and provide links to substantiate this claim. And do these
e-mail systems sniff into .zip or other compressed archive files to
check if they contain MDB or ADP files?
Lotus Notes is the #2 e-mail server in use, and it sends MDB files
without complaining.
>Do I understand what I'm talking about?? YES I DO.
Perhaps, but you seem unable to provide any substantiation. Read that
this way: no, I won't just take your word for it. You have no
credibility.
aaron...@gmail.com
files from zipped files.
and yes.. Access does have an 'open event'
it's called an autoexec macro. It's just that this is based on the
APPLICATION c:\AaronLoves.ADP
instead of being based on the program MSACCESS.exe
lotus notes isn't even #2 from what I read
you mean in the enterprise? I was thinking.. sendmail; etc
ok maybe i'll give you a #2 on that..
yeah I bitched up a storm to Microsoft about how it was being blocked..
but when all is said and done? Im glad that they're secure.. hotmail
and exchange do strip these files for the most part.. Frequently when I
_MUST_ email one.. I send it to 2 or 3 different webmails and one of
them lets it through
I think that hotmail is CONSIDERABLY more popular than this silly lotus
notes.. right?
-Aaron
Harlan Grove
>yes.. almost every program in the world specifically pulls MDB and ADP
>files from zipped files.
Provide substantiation. That's certainly NOT the case for Lotus Notes
or, FWLIW, AOL.
>and yes.. Access does have an 'open event'
...
If so, then there's the same security hole in Access that's in Excel.
>yeah I bitched up a storm to Microsoft about how it was being blocked..
>but when all is said and done? Im glad that they're secure.. hotmail
>and exchange do strip these files for the most part.. Frequently when I
>_MUST_ email one.. I send it to 2 or 3 different webmails and one of
>them lets it through
All you'd need to do is change the extension to something else and zip
it. Or zip it, change the extension on that zip file then zip the
renamed zip file.
>I think that hotmail is CONSIDERABLY more popular than this silly lotus
>notes.. right?
For businesses? What medium to large company uses hotmail for corporate
e-mail?
aaron...@gmail.com
exchange.. it doesn't work.
i can't zip.. change the extension.. none of the above.
it's not my fault that IBM and AOL don't follow Microsoft's best
practices for security.
I'd love to be able to email ADP files-- MDB files i dont give a rats'
ass about.
I am pretty darn sure that Microsoft screens stuff based on the
MimeType of the document.. and changing the extension doesn't change
the mimetype.
-Aaron
Harlan Grove
>nope i can't change the extension to get past it in hotmail and
>exchange.. it doesn't work.
Changing the extension alone was a long shot.
>i can't zip.. change the extension.. none of the above.
...
Likely you could uuencode, pass the result through binhex, and then
zip.
>it's not my fault that IBM and AOL don't follow Microsoft's best
>practices for security.
...
Security? Provided by either Exchange or Hotmail? Do you believe none
of the worms, trojans, visuses and other asorted malware that have
spread from Windows machine to Windows machine ever passed through
Exchange servers, and none has ever been sent from a Hotmail account?
Seriously?
>I am pretty darn sure that Microsoft screens stuff based on the
>MimeType of the document.. and changing the extension doesn't change
>the mimetype.
It may check the file's magic number before attaching it.
dbah...@hotmail.com
their email.
I think that Microsoft has done a terrific job these past 5 years in
cracking down.
-Aaron
Harlan Grove
>yeah.. i think that hotmail and exchange do a WONDERFUL job at securing
>their email.
>
>I think that Microsoft has done a terrific job these past 5 years in
>cracking down.
So all the reports of Windows malware infestation and propagation via
e-mail over the last 5 years was faked?
And I thought you could diminish your credibility any further. Silly me!
Harlan Grove
>dbah...@hotmail.com wrote...
>>yeah.. i think that hotmail and exchange do a WONDERFUL job at securing
>>their email.
Maybe Exchange does, but Hotmail is easy to confuse.
I just tried using Hotmail to send a compressed MDB file. I renamed the
MDB file with a different extension, zipped it using 7zip in 7z format,
then renamed that file with a different extension. Hotmail took it
without the warning message it showed when I tried to attach the same
MDB file directly.
So much for Hotmail.
aaron...@gmail.com
i think that ms has finally won the security war.. especially when
compared to companies like oracle
i think that exchange and hotmail do a WONDERFUL job of scanning
content; i haven't had an email virus or a problem in 2+ years.
Sure I have spyware; but i stay on top of that.. and it's not like the
spyware comes from exchange or hotmail
then again; i fully remember that nearly HALF of our virus problems in
Redmond ('03-'04) were the result of Excel Macro Viruses.
-Aaron