How many worksheets in a book?
 

Roughly how many worksheets can a book hold before it starts to 'slow down'.
i am fairly new to Excel and i am creating a workbook that will eventually
hold a lot of sheets. Will this cause me a problem in the future? i am using
the 2003 version.

thanks Kaitlin

How many worksheets in a book?
 

Kaitlin,

Theoritically up to 255. Of course the performance is based also to other
factors, i.e. processor speed, ram available, hard disk space etc.

Anyhow, what is the need to have a lot of sheets? more than 15-20? Most of
them will be just calculations on other sheets? Each sheet is a different
invoice? So, why not to have different books? (files).

I believe in some cases is better to move to another program, like access
database - Just a thought.

Hope this helps.

George

Ο χÏ�ήστης "Kaitlin.uk" Î*γγÏ�αψε:

Roughly how many worksheets can a book hold before it starts to 'slow down'.
i am fairly new to Excel and i am creating a workbook that will eventually
hold a lot of sheets. Will this cause me a problem in the future? i am using
the 2003 version.

thanks Kaitlin

How many worksheets in a book?
 

If you are asking that question, I would suggest that you have too many, and
should look at your design again. You should never need that sort of number
in a well designed, maintainable application.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Kaitlin.uk" wrote in message
...
Roughly how many worksheets can a book hold before it starts to 'slow
down'.
i am fairly new to Excel and i am creating a workbook that will eventually
hold a lot of sheets. Will this cause me a problem in the future? i am
using
the 2003 version.

thanks Kaitlin

How many worksheets in a book?
 

Kaitlin,

Take a look at "Data across multiple sheets" at
http://www.smokeylake.com/excel/excel_truths.htm before you get too far
along. It might apply to your situation.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Kaitlin.uk" wrote in message
...
Roughly how many worksheets can a book hold before it starts to 'slow
down'.
i am fairly new to Excel and i am creating a workbook that will eventually
hold a lot of sheets. Will this cause me a problem in the future? i am
using
the 2003 version.

thanks Kaitlin