Excel 2003 insert multiple worksheets fails

  • Thread starter Thread starter Laurel Eppstein
  • Start date Start date
L

Laurel Eppstein

We've all upgraded to Office 2003 in my workplace. I've set Excel to
open a new workbook with only one worksheet. When I need to have many
more than that, I will insert them one at a time. I read in the help
that by selecting a number of the worksheet tabs, and then choosing
insert worksheet, I could insert that many at a time. BUT, this still
inserts only one sheet for me. I had someone else in our office try
this on their computer, and lo and behold! it worked for them. But I
still can't get it to work for me.

What's going on??

Thanks,
Laurel
 
Hi Laurel

I notice if you have a Sheet.xlt template in your Xlstart folder this
will happen.

Do you have this template in your Xlstart folder?
 
I find this easier than selecting worksheets.

You can put an icon on your toolbar that inserts a worksheet.

Tools|Customize|commands tab|Insert Category

Drag that insert "worksheet" to your favorite toolbar.

If I need 6 worksheets, I just click on it 6 times. (I think it's pretty
quick.)
 
I think Laurel was trying to insert multiple worksheets into an existing
workbook.
 
Thank you all for your input! I just now got back to view the
responses. I do have a template sheet and workbook in my startup
folder, by choice. I like the suggestion below best, as it allows me to
start up with only one sheet, but add as needed.

Thanks all!!

-Laurel
 
Back
Top