maximum number of sheets

B

bat17

Well-known Member

Joined

Aug 15, 2003

Messages

1,470

• Oct 13, 2003

• #2

According to Help in XL2K it is limmited only by available memory.


HTH

Peter

 

Upvote 0

G

gaynard_nelson

Active Member

Joined

Dec 4, 2002

Messages

323

• Oct 13, 2003

• #3

Lino said:

what is the maximum number of sheets that you can have in a workbook?

Click to expand...

It used to be 256, it is probably more with the new versions. I have a customer using a speadsheet with 105 sheets, that is about 3 MB's in size. Everything works fine except saving takes 15-20 seconds.

When I built it I had problems adding sheets to the end of the sequence using an earlier version of Excel. I had to add sheets before the last sheet and then move them to the end.

 

Upvote 0

amigos

Active Member

Joined

Sep 23, 2003

Messages

407

• Oct 13, 2003

• #4

I asked myself the same question once.
so I started adding new sheets
and my computer creashed on 3150

 

Upvote 0

Iridium

Well-known Member

Joined

Jul 15, 2002

Messages

2,831

• Oct 13, 2003

• #5

As Peter (bat17) says the no. sheets in a workbook is limited by available memory so its up to your PC really - have a look at the help file 'Excel specifications and limits'

 

Upvote 0

W

WholesaleMelissa

New Member

Joined

Jun 1, 2011

Messages

2

• Jun 2, 2011

• #6

First off, I'd like to apologize in advance for posting in such an older thread, but I wanted to thank you guys for your insight. I'm pretty new to the world of Excel and I'm just now learning how to pull reports from our website. The excel reports I'm pulling are actually pretty large and I don't want to run into any issues if I happen to pull one that's larger than normal.

Anyway, thank you all for the excel help. It's more than appreciated! =)

 

Upvote 0

W

WholesaleMelissa

New Member

Joined

Jun 1, 2011

Messages

2

• Jun 2, 2011

• #7

First off, I'd like to apologize in advance for posting in such an older thread, but I wanted to thank you guys for your insight. I'm pretty new to the world of Excel and I'm just now learning how to pull reports from our website. The excel reports I'm pulling are actually pretty large and I don't want to run into any issues if I happen to pull one that's larger than normal.

Anyway, thank you all for the excel help. It's more than appreciated! =)

 

Upvote 0

S

sirexcel

New Member

Joined

Jul 20, 2011

Messages

3

• Jul 20, 2011

• #8

I was having some excel trouble. I was looking for something like this. I'm glad I came across this thread.

 

Upvote 0

J

JennyJones

New Member

Joined

Oct 13, 2011

Messages

1

• Oct 13, 2011

• #9

I was facing same problem some time back but i managed it

 

Upvote 0

D

Dronpy

New Member

Joined

Nov 3, 2011

Messages

1

• Nov 3, 2011

• #10

Got the same issue recently. I was almost stuck. Thank you for the instructions!

 

Upvote 0