Excel 2007 always opens Book1

starcope · 07-18-2008, 07:36 AM

Whenever I double click on an excel file in Explorer to open it in Excel 2007, another workbook named Book1 opens. My XLSTART folder is empty and I don't have a personal.xls fille. The problem it causes is that the spreadsheet I want to open starts without Automatic calculation because that's the way Book1 opens. How can I stop Book1 from opening.?

David M58 · 07-18-2008, 03:31 PM

You can go into Excel Options, select the Advanced tab, scroll down to the General section and check the entry in the field labeled At Startup, Open All Files In.

starcope · 07-21-2008, 06:31 AM

Thanks. I figured out the solution. We run an excel add-n called F9 which caused Book1 to open. Once I removed F9 from the add-in list, Book1 no longer opens.

07-18-2008, 07:36 AM	#1 (permalink)
starcope Registered User Join Date: Jul 2008 Posts: 2 OS: Vista Ultimate SP1	Excel 2007 always opens Book1 Whenever I double click on an excel file in Explorer to open it in Excel 2007, another workbook named Book1 opens. My XLSTART folder is empty and I don't have a personal.xls fille. The problem it causes is that the spreadsheet I want to open starts without Automatic calculation because that's the way Book1 opens. How can I stop Book1 from opening.?

07-18-2008, 03:31 PM	#2 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 97 OS: Windows XP SP3	Re: Excel 2007 always opens Book1 You can go into Excel Options, select the Advanced tab, scroll down to the General section and check the entry in the field labeled At Startup, Open All Files In.

07-21-2008, 06:31 AM	#3 (permalink)
starcope Registered User Join Date: Jul 2008 Posts: 2 OS: Vista Ultimate SP1	Re: Excel 2007 always opens Book1 Thanks. I figured out the solution. We run an excel add-n called F9 which caused Book1 to open. Once I removed F9 from the add-in list, Book1 no longer opens.