Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! -- Hth Kassie Kasselman Change xxx to hotmail "Alan" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "kassie" wrote in message ... 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! -- Hth Kassie Kasselman Change xxx to hotmail "Alan" wrote: 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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. Alan wrote: 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 "kassie" wrote in message ... 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! -- Hth Kassie Kasselman Change xxx to hotmail "Alan" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Microsoft Query is lost when opening Excel 2002 file | Excel Discussion (Misc queries) | |||
Microsoft Office XP Excel file opening problem | Setting up and Configuration of Excel | |||
opening non microsoft program from excel | Excel Discussion (Misc queries) | |||
Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) |