Excel in multiple sessions

[Guest]

A collegue is attempting to access data using vlookup in a spreadsheet from a
second spreadsheet which is opened in a separate session on his workstation.
It appears that multiple sessions of excel can't 'see' each other. Collegue
needs to have multiple sessions as he uses lots of spreadsheets with LOTS of
formulas. Attempting to open these sheets in single session usually results
in crashes and lost work.
Does anyone out there know anything about this?
Using Excel 2000 on Windows 2000 Professional sp4.
Thanks

 

[Dave Peterson]

=vlookup() worked ok for me--but by having the workbooks in separate instances,
it made life more miserable (less nice?) for me.

I had to type (not point and click) a formula like:
=VLOOKUP(A1,'C:\My Documents\excel\[book1.xls]Sheet1'!$A$1:$B$31,2,FALSE)

And if I changed a value in that lookup table, I had to save that workbook and
recalculate the formula workbook before it evaluated it correctly.

You might want to suggest opening some workbooks in the same instance (well, if
possible).

 

[Guest]

AAh! Fully qualified path is the key - why didn't I think of that? Thanks heaps
Unfortunately collegue can't open in same instance.
Thanks again

=vlookup() worked ok for me--but by having the workbooks in separate instances,
it made life more miserable (less nice?) for me.

I had to type (not point and click) a formula like:
=VLOOKUP(A1,'C:\My Documents\excel\[book1.xls]Sheet1'!$A$1:$B$31,2,FALSE)

And if I changed a value in that lookup table, I had to save that workbook and
recalculate the formula workbook before it evaluated it correctly.

You might want to suggest opening some workbooks in the same instance (well, if
possible).

A collegue is attempting to access data using vlookup in a spreadsheet from a
second spreadsheet which is opened in a separate session on his workstation.
It appears that multiple sessions of excel can't 'see' each other. Collegue
needs to have multiple sessions as he uses lots of spreadsheets with LOTS of
formulas. Attempting to open these sheets in single session usually results
in crashes and lost work.
Does anyone out there know anything about this?
Using Excel 2000 on Windows 2000 Professional sp4.
Thanks