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