View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do I keep formulas for being lost when saving in 2007?

What formulas?

Anyway, try rebuilding the calculation dependency tree with CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Shawn" wrote in message ...
|I have had a consistent problem with formulas disappearing from my workbooks
| and being replaced with "=N/A". It has happened probably 3 times in the last
| month. I am saving the files in 97-03 formats, but don't know why this would
| happen.
|
| PLEASE HELP!!! This workbook has a lot of formulas and I don't have time to
| continually go back and reinvent the wheel.
|
| Thanks,
| Shawn