Weird problem -- formulas get lost but their values stay in place

I have a client who uses Excel files that link out to other excel
files. The formulas in the "main" file calculate from data in the
linked files. So, the formula is in the main file. When they close the
main file and re-open it, the formulas are gone, but the last
calculated value remains.
Does anyone have an idea why this would happen?

Thanks,

Bill

One way might be because a "Before Save" or "Before Close" Macro is doing
a Copy > Paste special > Values........

Vaya con Dios,
Chuck, CABGx3



"Bill" <bdotson@gmail.com> wrote in message
news:1106528531.274367.138980@c13g2000cwb.googlegroups.com...
> I have a client who uses Excel files that link out to other excel
> files. The formulas in the "main" file calculate from data in the
> linked files. So, the formula is in the main file. When they close the
> main file and re-open it, the formulas are gone, but the last
> calculated value remains.
> Does anyone have an idea why this would happen?
>
> Thanks,
>
> Bill
>