Excel Workbook?

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[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

 

[Kris]

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.

http://office.microsoft.com/en-us/assistance/HP051992911033.aspx

 

[Guest]

Thank you, Gord. Merry Christmas