Hi,
According to your description, my understanding is that you need to close the file with the order in which the files are opened, am I right? If yes, this issue may be caused by the Excel files opened with the same instance. I recommend we try to follow this blog to open the workbooks by running separate instances.
Then, if this issue still exists, please try to following methods:
Methods one:
Open Excel-Options-Advanced-In General Options-Check Ignore Other Applications that use DDE.
Methods Two:
Update Registry.Run regedit. Press Start-Run, Type Regedit. Update the following registry keys
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/default: add [space]"%1"
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command. add [space]"%1"
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command. Rename KeyName from Command to Command_old
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec. Rename Keyname ddeexec to ddeexec_old
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/default. Add [space]"%1"
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command. Add [space]"%1"
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command. Rename KeyName from Command to Command_old
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec. Rename Keyname ddeexec to ddeexec_old
i.e.
32bit: "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE" "%1"
64bit:"C:\Program Files\Microsoft Office\Office15\EXCEL.EXE" "%1"
Please note: Backup the registry key before modify.
Next, this issue also may be caused by the third-party add-ins, please try to disable them and test.
Hope it's helpful.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"
Hi,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
Thanks
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"