I am running Excel 2000 on Windows XP Professional. For a long time, I was
able to open up files in separate windows and to create links between these
files by typing "=" in a cell of the target sheet and then clicking on a cell
in the source sheet. I recently installed a second monitor and video card on
my computer. Since then, I have been unable to both open multiple instances
and create links between those multiple instances. At first I was unable to
create multiple instanced. I have managed to create multiple instances in
three ways. First, I have gone to options - general - ignore other
applications. Second, I used the start menu shortcuts. Third, I tried
clicking on windows- share workbook - allow changes by more than one user. No
matter what I do, I am unable to create links between the windows that are
opened.
What I need is to be able to open files up in their own windows, which I can
move to separate screens and between which I can create links. Does anyone
know how I can do this?