Microsoft Excel Opening Problem

[Alan]

Hi

I'm using MS Office 2000 with XP professional SP2.

Lately when opening Excel (fresh or existing xls file), it just kept
opening, non-stop, from sheet 1 and going on until I press Esc key.

However, after pressing the Esc key to stop the automatic opening of the
unwanted sheets, the program functions normally.

When closing Excel, I have to close all the unwanted opened-sheets first
before the program can exit.

Any help to retify this problem is much appreciated.

Alan

 

[Guest]

When you refer to sheets, what do you actually mean. Are you saying that
Excel opens one file, but then keeps on adding worksheets non stop, in other
words, in stead of the normal 1, 2 or 3 sheets, it keeps adding new sheets.

Or do you mean that when you open Excel, it opens one workbook after the
other, each containing the normal 1, 2 or 3 worksheets. If so, are these
already existing files that is being opened, or are these named Book 1, Book
2, Book 3 and so on?

Sorry, but your question as it is phrased is a bit ambiguous. Elaborating a
bit might get you a result!

 

[Alan]

Normally, when open Excel, a copy of spreadsheet displays with left lower
corner shows Sheet1.

For my problem it keeps opening Sheet1, Sheet2, .... and keeps going on few
hundreds, 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 the problem of the unwanted Sheets automatically open when I
start the Excel programe whether from Excel.EXE or an existing saved xls
file?

Thanks

 

[Dave Peterson]

It sounds to me like you have a workbook that contains a macro that adds sheets
to a workbook each time that workbook is opened.

You job will be to find that workbook with the macro.

I'd start by looking in your XLStart folder (use windows start
button|search--and look for hidden files in hidden folders).

And open excel (sorry!) and use:
tools|options|general
and look for "at startup, open all files in:"
make sure that textbox is empty.