If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Second workbook (book2) opens automaticaly
Hi,
I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. Do anyone have an idea of what could be causing this? |
#2
|
|||
|
|||
Second workbook (book2) opens automaticaly
Look in your XLStart folder.
Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavid wrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. Do anyone have an idea of what could be causing this? -- Dave Peterson |
#3
|
|||
|
|||
Second workbook (book2) opens automaticaly
Hi,
I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART - No files C:\Program Files\Microsoft Office\Office\XLStart - the only file there is: personal.xls On Nov 11, 9:47*am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. *from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. * Do anyone have an idea of what could be causing this? -- Dave Peterson |
#4
|
|||
|
|||
Second workbook (book2) opens automaticaly
First, when you open excel, do you see personal.xls or is it a hidden workbook?
If you see it, that's not the usual choice for most users. I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavid wrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART - No files C:\Program Files\Microsoft Office\Office\XLStart - the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Second workbook (book2) opens automaticaly
Type this in an empty cell:
=cell("Filename",a1) When I did this, no path was found. it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. should I erase one of those folders?? On Nov 12, 9:13*am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. *I'd hide it.. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. *The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. |
#6
|
|||
|
|||
Second workbook (book2) opens automaticaly
If one of those xlstart folders is empty, then it shouldn't matter. (Did you
look for hidden files in either of those folders???) I don't have any real good guesses left... But some more questions... How are you starting excel? Are you double-clicking on a file in windows explorer? Are you clicking on a shortcut to an excel file? Are you clicking on a shortcut to excel itself? (Since you're writing that you're opening another workbook, it can't be the last choice, right?) If you're using a shortcut, are you sure that the target is correct??? ==== A complete guess that shouldn't cause any trouble and may (probably???) not work: Close excel windows start button|run excel /unregserver then windows start button|Run excel /regserver This resets a bunch of settings to factory defaults in the windows registry. DDavid wrote: Type this in an empty cell: =cell("Filename",a1) When I did this, no path was found. it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. should I erase one of those folders?? On Nov 12, 9:13 am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavid wrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART - No files C:\Program Files\Microsoft Office\Office\XLStart - the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Second workbook (book2) opens automaticaly
How about ToolsOptionsGeneral At Start up, open all file in:?
You did not mention if you had checked there for a path? Gord Dibben MS Excel MVP On Thu, 12 Nov 2009 05:55:16 -0800 (PST), DDavid wrote: Type this in an empty cell: =cell("Filename",a1) When I did this, no path was found. it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. should I erase one of those folders?? On Nov 12, 9:13*am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. *I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. *The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavid wrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART * - * No files C:\Program Files\Microsoft Office\Office\XLStart * *- * the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. *from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. * Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
Second workbook (book2) opens automaticaly
I checked, but it was empty.
On Nov 12, 7:00*pm, Gord Dibben gorddibbATshawDOTca wrote: How about ToolsOptionsGeneral At Start up, open all file in:? You did not mention if you had checked there for a path? Gord Dibben *MS Excel MVP On Thu, 12 Nov 2009 05:55:16 -0800 wrote: * * * * * * Type this in an empty cell: * * * * * * =cell("Filename",a1) When I did this, no path was found. *it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) *the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. *should I erase one of those folders?? On Nov 12, 9:13*am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. *I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. *The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavidwrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART * - * No files C:\Program Files\Microsoft Office\Office\XLStart * *- * the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. *from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. * Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson I che |
#9
|
|||
|
|||
Second workbook (book2) opens automaticaly
There are no hidden files in any of the folders,
Are you double-clicking on a file in windows explorer? Yes, in the explorer, or in the desktop. it doenst really matters where the file is, it always opens the Book2 Are you clicking on a shortcut to an excel file? No, just to the file itself Are you clicking on a shortcut to excel itself? No, I did the Unreg/registry, and as you said... no luck! On Nov 12, 11:34*am, Dave Peterson wrote: If one of those xlstart folders is empty, then it shouldn't matter. *(Did you look for hidden files in either of those folders???) I don't have any real good guesses left... But some more questions... How are you starting excel? * Are you double-clicking on a file in windows explorer? Are you clicking on a shortcut to an excel file? Are you clicking on a shortcut to excel itself? (Since you're writing that you're opening another workbook, it can't be the last choice, right?) If you're using a shortcut, are you sure that the target is correct??? ==== A complete guess that shouldn't cause any trouble and may (probably???) not work: Close excel windows start button|run excel /unregserver then windows start button|Run excel /regserver This resets a bunch of settings to factory defaults in the windows registry. DDavidwrote: * * * * * * * Type this in an empty cell: * * * * * * * =cell("Filename",a1) When I did this, no path was found. *it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) *the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. *should I erase one of those folders?? On Nov 12, 9:13 am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. *I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. *The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavidwrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART * - * No files C:\Program Files\Microsoft Office\Office\XLStart * *- * the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. *from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. * Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
|
|||
|
|||
Second workbook (book2) opens automaticaly
I'm out of guesses.
Sorry. DDavid wrote: There are no hidden files in any of the folders, Are you double-clicking on a file in windows explorer? Yes, in the explorer, or in the desktop. it doenst really matters where the file is, it always opens the Book2 Are you clicking on a shortcut to an excel file? No, just to the file itself Are you clicking on a shortcut to excel itself? No, I did the Unreg/registry, and as you said... no luck! On Nov 12, 11:34 am, Dave Peterson wrote: If one of those xlstart folders is empty, then it shouldn't matter. (Did you look for hidden files in either of those folders???) I don't have any real good guesses left... But some more questions... How are you starting excel? Are you double-clicking on a file in windows explorer? Are you clicking on a shortcut to an excel file? Are you clicking on a shortcut to excel itself? (Since you're writing that you're opening another workbook, it can't be the last choice, right?) If you're using a shortcut, are you sure that the target is correct??? ==== A complete guess that shouldn't cause any trouble and may (probably???) not work: Close excel windows start button|run excel /unregserver then windows start button|Run excel /regserver This resets a bunch of settings to factory defaults in the windows registry. DDavidwrote: Type this in an empty cell: =cell("Filename",a1) When I did this, no path was found. it is always with this name when I first open a workbook file. Personal.xls is hidden, it does not show at startup One thing that I have noticed is that if I open a file "File 1" (excel is closed) the file opens and the BOOK2 opens too., then I close the Book2 workbook and for as long as I have the "file 1" open, I can open as many other files as I want, and the book2 does not comes again, until I close all instances of excel and open a file again it comes up with the book2. Only the two folders Xlstart that i mention before appeared in command line. should I erase one of those folders?? On Nov 12, 9:13 am, Dave Peterson wrote: First, when you open excel, do you see personal.xls or is it a hidden workbook? If you see it, that's not the usual choice for most users. I'd hide it. Open excel activate personal.xls Window|Hide (xl2003 menus) Close excel and answer yes to the save prompt (since you changed the personal.xls workbook by hiding it). Then check by reopening excel. If that doesn't work... There's a setting in windows that allows users to hide extensions in windows explorer--and excel respects that option and does not display the extension in the title bar. So the next thing to check is to see if that book2 is really book2.xls (an existing workbook) or a newly created workbook. Open excel. Activate Book2 Type this in an empty cell: =cell("Filename",a1) This will return the name (including drive and path) if the file has been saved. The cell will look empty if the file has never been saved. If the file exists, make a note of its location, close excel and delete it. There's an option under Tools|Options|General Tab (xl2003 menus) that allows the use to specify a folder so that "at startup, open all files in:" that folder will will be opened. Most people leave that entry empty. If the file doesn't exist, then I'm guessing that you have another XLStart folder (you can have lots depending on your version of windows and upgrade path). Try shelling to DOS: Windows start button|Run CMD (to get to the command prompt) type this and see if any more XLStart folders show up. Dir C:\xlstart /s DDavidwrote: Hi, I found two folders: C:\Documents and Settings\xxxxxx\Application Data\Microsoft\Excel \XLSTART - No files C:\Program Files\Microsoft Office\Office\XLStart - the only file there is: personal.xls On Nov 11, 9:47 am, Dave Peterson wrote: Look in your XLStart folder. Report what you find. I'm guessing that you have a file in that folder that's causing the trouble. DDavidwrote: Hi, I use Excel 2000 at work, and I recently started to get this issue, when I first open any excel file, another workbook named "Book2" opens automaticaly along with the first file. from then on, I can open other files and no other books comes up. it only does it when I open a first instance of excel. Do anyone have an idea of what could be causing this? -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|