Wednesday, December 8, 2010

Closing Single Excel File Closes All Excel-Solved!!

Hi All,
Solved!!You might have facing this problem, like when you opened a Excel file and along with it you have open other Excel files, so when you Close any of the Excel files it closes all the Excel file,You can overcome this the Solution mention below.
1.Open the Windows Explorer-Go the Tools-Folder Options
2.Select Files Types.
3.Now Scroll Down to XLS and Click on Advanced4.Select Open , then Edit5.Here untick "Use DDE"
6.Change "Application Used to Perform this action" to
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "%1"7.If you are using Office 2003 you need to select "C:\Program Files\Microsoft Office\Office11\EXCEL.EXE" "%1"Click on OK

Now check by opening Multiple Excel file, you can see it normally, when you close a single Excel file it will close only single Excel.

Regards
Raju Gunnal

10 comments:

  1. How to do this in VISTA?

    ReplyDelete
  2. Thankyou

    from Sudheer

    ReplyDelete
  3. Thanks dude,
    it really worked like a charm for me. good work dude.

    ReplyDelete
  4. Hello great solution, but... do You have some hint for windows 7?

    ReplyDelete
  5. Excellent.

    Why would Microsoft have different behavior for excel vs word - another undocumented feature.

    ReplyDelete
  6. Sorry dude, its didnt worked for me. when i untick DDE and close . it still does not close 1 file. When checked again the setting were not taken for DDE . The DDE was still checked and not allowing to untick as when try to untick it automatically tick itself after clicking on okay. So please mention something in registry to take the changes effect in DDE how to untick it form registry.

    ReplyDelete
  7. I tried it & excel stopped working! :(

    ReplyDelete