Excel Workbook?

P

Patty

I need to find out how many sheets will an Excel Workbook hold. I am trying
to creast a master list with employees names for training; however, I have to
create a separate sheet for each employee to track all the training the
employee has taken over the course of the year. Please let me know as soon
as possible, or where I can look on line. Thank you.
 
M

Michael

Hi Patty. If I'm not mistaken, each workbook will now hold 255 sheets. In
the new Excel version coming out in 2006, it will be over 1,000.
 
C

CLR

I recommend you build a single Database with all the employees and all their
training on one sheet, instead of individual sheets for each
employee........it will make it a lot easier later to sort and find
things.......I know, it will be a lot of rows, I just did one that is over
12,000 rows long..........but it works like a champ.

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

Michael/Patty

255 maximum default in a new workbook.

The number of additional worksheets depends upon resources.

No need to go on line to find this info.

Try Excel's Help on "Specifications"


Gord Dibben Excel MVP
 
Top