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
|