Excel 2003 not allowing link to another workbook

[JOHANNA]

My I.T. department just changed out my computer for a new one. Now my Excel 2003 will not allow me to do lookup tables off of other worksheets or workbooks. Does anyone know of any options that need to be selected in order to allow me to link to other worksheets?

Thanks!

 

[Jonmo1]

It probably has nothing to do with Excel...
More likely related to Network Permissions.

Can you actually open any of the books you are trying to link to?

 

[JOHANNA]

Yes, I have both of the workbooks open. When I try to click a cell or group of cells in the second workbook it doesn't fill in the formula bar.

 

[Jonmo1]

OK, make sure both books are opened in the same instance of Excel..

Open the first book (the one with your formulas).
Then, from within that book, go to File - Open - Browse to and open the 2nd file.

Now you should be able to link.

 

[JOHANNA]

That worked! Is there a way to make it so that you can open a workbook from Explorer and it automatically opens in the same Excel session?

 

[Jonmo1]

See post # 5 by pcg01

http://www.mrexcel.com/forum/showthread.php?t=280472