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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weird Error with Arrays 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0
Weird Formula Problem 4
Formula's not calculatin in Excel 2007 1
Excel Stop Excel from displaying rounded values 4
Need help entering cell formula 1
Excel2007 Replace formulas with {=#Value!} when saving file 2

Back
Top