Reference to Another Worksheet

[wiscokid]

I built a formula to access a cell in another worksheet on our netwrok, currently I am getting a #REF!

I am trying to make the date in the following formula (which works) a variable
='http://wss/Returns CC/2011/[Nav_Summary_20110930.xls]Summary'!$D$90


Formula:
=INDIRECT("http://wss/Returns CC/2011/[Nav_Summary_'"&B89&"'.xls]Summary'!$D$90")

Where cell B89= 20110930



Thank you in Advance

 

[FormR]

Looks like you are missing an apostrophe at the start have extra apostrophes in the middle;<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
try: =INDIRECT("'http://wss/Returns CC/2011/[Nav_Summary_"&B89&".xls]Summary'!$D$90")

 

[wiscokid]

Thank You FormR, but I am still getting a #REF!

Any other ideas why this may be occuring?

Thanks

WiscoKid

 

[wiscokid]

I think I figured out the reason I am getting the #REF! is because the spreadsheet I am linking to is not open. Does the INDIRECT function only work with open workbooks? And if so, is there another function I can use to do what I am attempting to do?

Thank You very much

WiscoKid

 

[helmbrecbe15]

How about: =INDIRECT("http://wss/Returns CC/2011/[Nav_Summary_"&B89&".xls]'Summary'!$D$90")

Have seen tab names have apostrophes on both sides of the name.