Hi
I'm using MS Office 2000 with XP professional SP2.
Normally, when open Excel, a copy of spreadsheet displays with left lower
corner shows Sheet1.
Lately when I start Excel, it keeps opening Sheet1, Sheet2, .... and keeps
going on few
hundred Sheets, OR, when I open an existing saved xls file, the unwanted
Sheets
keep opening, until I press the Esc key.
I can work as usual on the spreadsheet and saved to a xls file, and I must
close all the unwanted Sheets (the number of Sheets that opened depend on
when I pressed the Esc key) to exit the Excel program.
How to solve this problem of the unwanted Sheets that automatically open
when I
start the Excel programe, whether from Excel.exe or opening an existing
saved xls
file?
Any help to retify this problem is much appreciated.
Alan
Rick Rothstein (MVP - VB) - 14 Jul 2007 19:32 GMT
You seem to be describing something different than this, but let's be sure.
Go to Tools/Options in Excel's menu and select the General tab on the dialog
box that appears. What number do you have in the field labeled "Sheets in
new workbook"?
Rick
> Hi
>
[quoted text clipped - 22 lines]
>
> Alan