Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel not linking
Whenever I open a second instance of excel I cannot link the two excel
workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks |
#2
|
|||
|
|||
The whole idea of Windows is not to have to open multiple instances of a
program, but to open multiple files in one instance? "shaya" wrote: Whenever I open a second instance of excel I cannot link the two excel workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks |
#3
|
|||
|
|||
I realise that but the problem I am having is that excel treats the two files
as two seperate instances. "Kassie" wrote: The whole idea of Windows is not to have to open multiple instances of a program, but to open multiple files in one instance? "shaya" wrote: Whenever I open a second instance of excel I cannot link the two excel workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks |
#4
|
|||
|
|||
If you want to try to eliminate opening that second instance:
Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. shaya wrote: I realise that but the problem I am having is that excel treats the two files as two seperate instances. "Kassie" wrote: The whole idea of Windows is not to have to open multiple instances of a program, but to open multiple files in one instance? "shaya" wrote: Whenever I open a second instance of excel I cannot link the two excel workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks -- Dave Peterson |
#5
|
|||
|
|||
Thanks for you reply but that does not solve the problem.
If I click on 'new' from within excel it opens a new workbook but does not create a new button on the taskbar however under the windows menu you can select either worksheet.. If i click an icon to open excel it opens a new button on the taskbar but both workbooks do not appear in the 'window' menu. It is then not possible to link the two workbooks. "Dave Peterson" wrote: If you want to try to eliminate opening that second instance: Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. shaya wrote: I realise that but the problem I am having is that excel treats the two files as two seperate instances. "Kassie" wrote: The whole idea of Windows is not to have to open multiple instances of a program, but to open multiple files in one instance? "shaya" wrote: Whenever I open a second instance of excel I cannot link the two excel workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks -- Dave Peterson |
#6
|
|||
|
|||
What version of excel are you using?
If you're using xl2k or higher, then checking tools|options|view tab|windows in taskbar should make it show up in the windows taskbar. But you can override that (kind of) if you're using windows XP. Rightclick on the windows taskbar and choose properties. do you have "group similar taskbar buttons" checked If yes, then when I had windows in taskbar checked, I would see a list of the similar buttons when I clicked on a "grouped" icon on the taskbar. --- Windows in taskbar was added in xl2k. shaya wrote: Thanks for you reply but that does not solve the problem. If I click on 'new' from within excel it opens a new workbook but does not create a new button on the taskbar however under the windows menu you can select either worksheet.. If i click an icon to open excel it opens a new button on the taskbar but both workbooks do not appear in the 'window' menu. It is then not possible to link the two workbooks. "Dave Peterson" wrote: If you want to try to eliminate opening that second instance: Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. shaya wrote: I realise that but the problem I am having is that excel treats the two files as two seperate instances. "Kassie" wrote: The whole idea of Windows is not to have to open multiple instances of a program, but to open multiple files in one instance? "shaya" wrote: Whenever I open a second instance of excel I cannot link the two excel workbooks. It works fine if I click on new from within the first workbook, but if i open a new workbook from the shortcut the two workbooks do not seem to be connnected at all. If i go to the window menu it also does not list both workbooks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Linking Excel to Outlook?? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
In Excel Auditing linking lines(blue colour) are not shown proper. | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |