can someone tell me why this isnt working?

=INDIRECT("'C:\PCS Connection\[Compan
Discounts.xls]Sheet1'!$D$"&'C:\PCS
Connection\[Company Discounts.xls]Sheet5'!$A$1)

i'm los

--
samccun
-----------------------------------------------------------------------
samccune's Profile: http://www.excelforum.com/member.php...fo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26340

=Indirect() only works if the sending workbook is open.

And it looks like "c:\pcs connection\company discounts.xls" is closed from your
formula.

samccune wrote:

can someone tell me why this isnt working?

=INDIRECT("'C:\PCS Connection\[Company
Discounts.xls]Sheet1'!$D$"&'C:\PCS
Connection\[Company Discounts.xls]Sheet5'!$A$1)

i'm lost

--
samccune
------------------------------------------------------------------------
samccune's Profile: http://www.excelforum.com/member.php...o&userid=14597
View this thread: http://www.excelforum.com/showthread...hreadid=263409

--

Dave Peterson