New book in excel 2007

[sburkhar]

Every time I open an existin document in Excel 2007 it also opens a blank New Workbook. Is there somewhere that I can turn this option off? It's very annoying.

 

[pboltonchina]

I've had this problem and it sounds to me like you have a blank workbook stored in the XlStart folder located at

C:\Program Files\Microsoft Office\Office12\XLSTART

Check in there and if there is anything other than Personal.xlsm or Personal.xlsb then get rid of it and try opening Excel again.
I was playing with macros and the macro saved a file to the same folder as the macro workbook which was XlStart.
HTH

 

[sburkhar]

there's nothing in the XLSTART file.
I misspoke earlier. It actually opens a BOOK1 with each document that I open. I don't know if this is any different than an new workbook, but I want to be accurate.

 

[pboltonchina]

In Excel Options, under Advanced is an option to put a folder address in to open any files in the folder on Excel start. Is that blank?

 

[sburkhar]

I don't see that option in the Advanced window under Excel Options

 

[pboltonchina]

Scroll down to the bottom of the in the General section it says "At Startup, open all files in:" and there is a box for a folder address, ensure it is blank

 

[sburkhar]

oh! Now I see it.

yes - it's blank