Only One New Worksheet

  • Thread starter Thread starter Don Pistulka
  • Start date Start date
D

Don Pistulka

XL and MS Office Professional 2003

I have changed the number of "sheets in new worksheet"
(Tools/Options/General) to 6, however I keep getting only one sheet when I
open a new workbook. No matter how many sheets I try in the option, I still
only get one. I have also tried running "Detect and Repair". Any Ideas?


Don
 
Hi,
Just the thought:
Try to locate default template in XLStart directory (Program Files\Microsoft
Office\Office10\XLStart).
Open it and see what Options...General are set to.
HTH
Paul
 
That file in your XLStart is named book.xlt.

If it has only one worksheet, then you can add some more.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
How to insert new worksheet based on # of rows in a data sourch 2
Spelling checker problem on a specific worksheet only 1
Formula Audit mode active in one column only; cannot kill. 2
consolidate workbooks to worksheets in one workbook? 1
Copy to new worksheet 1
Paste Values in linked Cells Only 4
Link one worksheet in a workbook to another worksheet in same work 1

Back
Top