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

B

Bill

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top