One way I've seen this happen is if you have one or more of the linked files
open and you save themto the C:\ drive. This will cause the links in Excel
to follow to the new path (C:\). You didn't mention email, but I've seen
this happen when folks email files back and forth. The links may get changed
to the local Outlook temp folder.

Can you provide any more specific information about when it seems to happen?


--
Happy calculating!

If you like this answer, please click ''Yes.''




"Peg" wrote:

I work with a rather large spreadsheet that has several hundred external
formulas. All of the spreadsheets are on a server drive. Excel seems to be
changing the path of the formulas from the server (EX: U) to my C: drive. Is
there any way I can stop this from happening?
--
Peg G.