• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i stop opening a blank workbook while opening the existing workbook

D

dvsdasari

New Member
Hi Gurus,


Thanks for lot of help and sharing your thoughts through this website.


I have a problem that whenenver i am trying to open a existing workbook, it is opening along with a new workbook.


I don't know what is reason behing this.


I am using excel 2007 on Windows7.


Please help me in this regard.


Thanks-Sekhar Dasari
 
Hi, dvsdasari!


It might be for many reasons:

a) you have a blank workbook in your Excel start folder (XLSTART):

File, Options, Advanced General, At start open all files in

or check: C:Users<UserName>AppDataRoamingMicrosoftExcelXLSTART

b) you have a personal workbook that opens a new file:

C:Users<UserName>AppDataRoamingMicrosoftExcelXLSTARTPERSONAL.XLSB

c) you have and add-in that opens a new file:

go to VBA editor (Alt-F11) and check for .xlam files opened (top left window pane)

d) you're running Excel from a shortcut that has modified command line switchs and parameters:

right (or alternate) button on icon or menu entry or shorcut, then properties, shortcut and check running program and parameters


I don't remember any more now. Review those and hope you'll find the reason.


Regards!
 
Hi, dvsdasari,


On the bottom menu bar are the workbooks Book1:1 and Book1:2 (or something like that)? If so close Book1:2, then Book1:1 should automatically change to Book1, then save Book1 and close it. On re-opening you should then have one workbook
 
You must log in or register to reply here.
Back
Top