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
Great!
ReplyDeleteHow to do this in VISTA?
ReplyDeleteThankyou
ReplyDeletefrom Sudheer
Cool
ReplyDeleteThanks dude,
ReplyDeleteit really worked like a charm for me. good work dude.
Hello great solution, but... do You have some hint for windows 7?
ReplyDeleteExcellent.
ReplyDeleteWhy would Microsoft have different behavior for excel vs word - another undocumented feature.
Thank you.. it really help me a lot...
ReplyDeleteSorry 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.
ReplyDeleteI tried it & excel stopped working! :(
ReplyDelete