Excel
From Attie's Wiki
(Difference between revisions)
(Created page with "==Make Excel use Multiple Instances... like it should== This will fix the stupid ''Yeah, I can't open that because it's got the same name as another file that's already open''...") |
m |
||
| Line 3: | Line 3: | ||
Only allowing one open file with a given name is a key requirement of the following: | Only allowing one open file with a given name is a key requirement of the following: | ||
| − | {{quote|If you had a cell ='[Book1.xlsx]Sheet1'!$G$33 and you had two books named 'Book1' open, there's no way to tell which one you mean.}} | + | {{quote|text=If you had a cell ='[Book1.xlsx]Sheet1'!$G$33 and you had two books named 'Book1' open, there's no way to tell which one you mean.}} |
===Use_Multi_Inst.reg=== | ===Use_Multi_Inst.reg=== | ||
Latest revision as of 12:40, 15 August 2014
[edit] Make Excel use Multiple Instances... like it should
This will fix the stupid Yeah, I can't open that because it's got the same name as another file that's already open.
Only allowing one open file with a given name is a key requirement of the following:
If you had a cell ='[Book1.xlsx]Sheet1'!$G$33 and you had two books named 'Book1' open, there's no way to tell which one you mean.
[edit] Use_Multi_Inst.reg
Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command] @="\"C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE\" /dde \"%1\"" "command"=- [-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec] [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command] @="\"C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE\" /dde \"%1\"" "command"=- [-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]
[edit] Use_One_Inst.reg
Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command] @="\"C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE\" /dde" "command"=hex(7):79,00,68,00,31,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\ 21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\ 00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,6c,00,56,00,57,00,41,00,\ 28,00,54,00,56,00,6b,00,4d,00,41,00,49,00,53,00,35,00,44,00,68,00,5d,00,33,\ 00,6e,00,56,00,4f,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00 [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec] @="[open(\"%1\" /ou \"%u\")]" [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\application] @="Excel" [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\topic] @="system" [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command] @="\"C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE\" /dde" "command"=hex(7):79,00,68,00,31,00,42,00,56,00,35,00,21,00,21,00,21,00,21,00,\ 21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\ 00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,6c,00,56,00,57,00,41,00,\ 28,00,54,00,56,00,6b,00,4d,00,41,00,49,00,53,00,35,00,44,00,68,00,5d,00,33,\ 00,6e,00,56,00,4f,00,20,00,2f,00,64,00,64,00,65,00,00,00,00,00 [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec] @="[open(\"%1\" /ou \"%u\")]" [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\application] @="Excel" [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\topic] @="system"
