HELP, dont know how to describe this in a subject line

[samccune]

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

 

[Dave Peterson]

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

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

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