Can you have a static file location in a formula?

  • Thread starter Thread starter TwEaKFrEaK
  • Start date Start date
T

TwEaKFrEaK

I would like to have a static file location that does not change if
email the workbook to somebody. Is this possible?

Here is an example of what I would like to do.

=IF(L8=TRUE,'C:\Documents\Football\Week 3\[Pool Score Sheet.xls]Scorin
Tab'!$B3,IF('C:\Documents\Football\Week 3\[Pool Score Sheet.xls]Scorin
Tab'!$B3=0,1,0))

I would like the C: Documents ... to never change. I will be emailin
this sheet so I want to formula to refer to my computer and not th
recipent. Please help
 
Hi
and you're on a network so the recipient could access this file from
his computer?. if yes then why email at all?
 
Back
Top