I have a 2mb workbook. I have 10 sheets in the workbook set up with formulas
to calculate labor cost (hours x pay). I have made 20 copies of this sheet
and need to continue to add more. The program will not copy the sheet
anymore times. How do I continue to copy and add sheets in the same workbook?

Anita

You say you have 10 sheets and you made 20 copies of "this sheet".

Which "sheet" did you copy?

Or did you mean 20 copies of each of 10 sheets for a total of 200 sheets?

"Will not copy" means what? Error message?


Gord Dibben MS Excel MVP

On Sat, 11 Nov 2006 07:40:02 -0800, Anita
wrote:

I have a 2mb workbook. I have 10 sheets in the workbook set up with formulas
to calculate labor cost (hours x pay). I have made 20 copies of this sheet
and need to continue to add more. The program will not copy the sheet
anymore times. How do I continue to copy and add sheets in the same workbook?

Sorry I was unclear. I was trying to make 20 plus copies of one sheet in the
workbook. Sheet labeled 'labor 1'. Was able to copy this sheet 20 times.
When I try to 'make a copy' again I don't get any error message, just will
not copy sheet.

"Gord Dibben" wrote:

Anita

You say you have 10 sheets and you made 20 copies of "this sheet".

Which "sheet" did you copy?

Or did you mean 20 copies of each of 10 sheets for a total of 200 sheets?

"Will not copy" means what? Error message?


Gord Dibben MS Excel MVP

On Sat, 11 Nov 2006 07:40:02 -0800, Anita
wrote:

I have a 2mb workbook. I have 10 sheets in the workbook set up with formulas
to calculate labor cost (hours x pay). I have made 20 copies of this sheet
and need to continue to add more. The program will not copy the sheet
anymore times. How do I continue to copy and add sheets in the same workbook?