software

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.

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.
--
Sincerely, Michael Colvinquot;Pattyquot; wrote:

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

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
quot;Pattyquot; wrote:

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

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 quot;Specificationsquot;Gord Dibben Excel MVP

On Mon, 19 Dec 2005 11:58:02 -0800, quot;Michaelquot;
gt; wrote:

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

Patty wrote:
gt; I need to find out how many sheets will an Excel Workbook hold. I am trying
gt; to creast a master list with employees names for training; however, I have to
gt; create a separate sheet for each employee to track all the training the
gt; employee has taken over the course of the year. Please let me know as soon
gt; as possible, or where I can look on line. Thank you.office.microsoft.com/en-us/as...992911033.aspxThank you, Gord. Merry Christmas
--
Sincerely, Michael Colvinquot;Gord Dibbenquot; wrote:

gt; Michael/Patty
gt;
gt; 255 maximum default in a new workbook.
gt;
gt; The number of additional worksheets depends upon resources.
gt;
gt; No need to go on line to find this info.
gt;
gt; Try Excel's Help on quot;Specificationsquot;
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt; On Mon, 19 Dec 2005 11:58:02 -0800, quot;Michaelquot;
gt; gt; wrote:
gt;
gt; gt;Hi Patty. If I'm not mistaken, each workbook will now hold 255 sheets. In
gt; gt;the new Excel version coming out in 2006, it will be over 1,000.
gt;