How do I keep formulas for being lost when saving in 2007?

[Shawn]

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

 

[Niek Otten]

What formulas?

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|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

 

[Shawn]

The formulas in the cell that it happened to last time was the following:

=IF(B11="","",((G11-E11)/NETWORKDAYS(D11,F11))*22)

I don't follow what you mean by the calculation dependency tree. Sorry, I'm
still a bit of a novice. Thanks for the help!

Shawn

 

[macropod]

Hi Shawn,

Make sure you're saving in 'xls' format - the problem you describe happens if you save in 'csv' format.

Cheers

 

[Shawn]

I've been saving in 'xls', but what I've noticed so far is that if I save in
'xlsm' I haven't had the problem occur yet. I was thinking that there was a
problem with compatability mode or something that I didn't know about.
Thanks for the help!

Shawn

Hi Shawn,

Make sure you're saving in 'xls' format - the problem you describe happens if you save in 'csv' format.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

The formulas in the cell that it happened to last time was the following:

=IF(B11="","",((G11-E11)/NETWORKDAYS(D11,F11))*22)

I don't follow what you mean by the calculation dependency tree. Sorry, I'm
still a bit of a novice. Thanks for the help!

Shawn