Hello,
I've been working on a huge excel file for a while and I'm trying to make
it easier to use. My problem is that when it is moved from the template
folder to a working folder the formulas referencing a file in the template
folder have their path changed in the formula and have to have the links
updated. Since the file is protected it's impossible for the users to chance
the source. It's wierd because it will still pull information, but if
information is changed in the external data file the updated doesn't get
ported over.

I need some like the $ command to stop Excel from changing the drive path.
I'd rather have no drive path and have all the reference files open, then the
working directory file is opened. Or statically assign the proper path for
the reference file sitting in the template folder.

Any help, without having to use VB scriping would be apprciated. Thanks