Menu
I am using Excel 2010 and want to manage a large Excel files.
So I would like to open a new Excel Instance when opening every file from my Windows Explorer. At the point all files are opened in the same Excel Instance.
Any assistance is kindly appreciated.
John.
[ I fould this: http://www.online-tech-tips.com/ms-office-tips/how-to-open-a-new-instance-of-excel-2007-workbooks/ ]
832
On the Edit menu, point to New, and then select DWORD Value. Enter DisableMergeInstance, and then press Enter. In the Details pane, right-click DisableMergeInstance, and then select Modify. In Value data, enter 1, and then click OK.
Click the Recent Workbook option (it's at the top-left) Click the 'Recover Unsaved Workbooks' button which is at the bottom. In the dialog box that opens, scroll through the list of unsaved Workbooks and open the one you want.
File –> Options –> Advanced –> Scroll down into the “General” section –> UNCHECK the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox. This will fix the problem.
Go to a folder in Windows Explorer, then Tools -> Folder Options, then the File Types tab. For each of XLSM, XLSB, XLSX, etcetera, select it, then click Advanced, select Open in the Actions list, then click Edit.
Adjust the settings to:
Application used to perform action: - "C:...\EXCEL.EXE" "%1"
Use DDE - Checked
DDE Message *LEAVE BLANK*
Application - Excel
Topic - System
62
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
