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

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
One way might be because a "Before Save" or "Before Close" Macro is doing
a Copy > Paste special > Values........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top