Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I double click on a spreadsheet and it opens, but it also opens the default
book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You must have a book1 file in your XLSTART folder.
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Newtek" wrote in message ... I double click on a spreadsheet and it opens, but it also opens the default book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
that would be a negative. I only have an addin for adobe acrobat and DDE.
There is no book1 or anything else. Any other thoughts? "Anne Troy" wrote: You must have a book1 file in your XLSTART folder. http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Newtek" wrote in message ... I double click on a spreadsheet and it opens, but it also opens the default book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can look in Tools Options General tab. Where you see "At Startup, open
all files in" ... is there a path shown there? If so, can you check that path for a file? Last, open Excel by double-clicking a different excel document, and when you are at the window that says Book1, select File-SaveAs from the menu and see is it pointing anywhere where you can see there is a Book1 Saved? "Newtek" wrote in message ... that would be a negative. I only have an addin for adobe acrobat and DDE. There is no book1 or anything else. Any other thoughts? "Anne Troy" wrote: You must have a book1 file in your XLSTART folder. http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Newtek" wrote in message ... I double click on a spreadsheet and it opens, but it also opens the default book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There is nothing in that field. The path shows as empty.
The save-as path is pointed to My documents which has nothing in it at all besides windows default folders. There are no other documents in that folder including the book1. I have done a complete search on PC and found no documents named *book1*. I know it seems to be a fluke, but this is happening on many and multiple machines and I am unaware of a logical reason this is happening as there are plenty of other PC's that have same image on them and are not affected by this. Thanks again and look forward to finding a solution for this. Newtek "William Benson" wrote: You can look in Tools Options General tab. Where you see "At Startup, open all files in" ... is there a path shown there? If so, can you check that path for a file? Last, open Excel by double-clicking a different excel document, and when you are at the window that says Book1, select File-SaveAs from the menu and see is it pointing anywhere where you can see there is a Book1 Saved? "Newtek" wrote in message ... that would be a negative. I only have an addin for adobe acrobat and DDE. There is no book1 or anything else. Any other thoughts? "Anne Troy" wrote: You must have a book1 file in your XLSTART folder. http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Newtek" wrote in message ... I double click on a spreadsheet and it opens, but it also opens the default book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Look for more than one XLStart folder.
Depending on your upgrade path, you could have multiple versions. Make sure you look for hidden folders, too. Check each of these. And if that doesn't help, try removing those addins and trying it. If it works ok, put one back and test it again. (and then put back the next and test it (and so forth...).) Chip Pearson has some notes on how to diagnose startup errors at: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes at: http://www.jkp-ads.com/Articles/StartupProblems.htm Newtek wrote: There is nothing in that field. The path shows as empty. The save-as path is pointed to My documents which has nothing in it at all besides windows default folders. There are no other documents in that folder including the book1. I have done a complete search on PC and found no documents named *book1*. I know it seems to be a fluke, but this is happening on many and multiple machines and I am unaware of a logical reason this is happening as there are plenty of other PC's that have same image on them and are not affected by this. Thanks again and look forward to finding a solution for this. Newtek "William Benson" wrote: You can look in Tools Options General tab. Where you see "At Startup, open all files in" ... is there a path shown there? If so, can you check that path for a file? Last, open Excel by double-clicking a different excel document, and when you are at the window that says Book1, select File-SaveAs from the menu and see is it pointing anywhere where you can see there is a Book1 Saved? "Newtek" wrote in message ... that would be a negative. I only have an addin for adobe acrobat and DDE. There is no book1 or anything else. Any other thoughts? "Anne Troy" wrote: You must have a book1 file in your XLSTART folder. http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Newtek" wrote in message ... I double click on a spreadsheet and it opens, but it also opens the default book1. If I only open excel and close book1 and then open a spreadsheet there is no issue. So why is excel wanting to open the default book when opening an already created excel doc and second, how can I disable or resolve this issue to not open the book1 when opening a spreadsheet but still have it open book1 when I simply open excel only? Thanks in advance, Newtek -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel opens in Autosave.How do I delete it so it opens in Book1? | Setting up and Configuration of Excel | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
Eliminating book1.xls when opening existing spreadsheet | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel |