| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep formulas for being lost when saving in 2007?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep formulas for being lost when saving in 2007?
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 "Niek Otten" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep formulas for being lost when saving in 2007?
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] ------------------------- "Shawn" wrote in message ... 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 "Niek Otten" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep formulas for being lost when saving in 2007?
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 "macropod" wrote: 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] ------------------------- "Shawn" wrote in message ... 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 "Niek Otten" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Wrap lost when pasting into cell | Excel Discussion (Misc queries) | |||
| lost work without saving it. can I get it back? | Excel Discussion (Misc queries) | |||
| Lost all my work in Excel 2007 | Excel Discussion (Misc queries) | |||
| Analysis Services add in - features lost in 2007 | Excel Discussion (Misc queries) | |||
| Lost my original spreadsheet by saving over it with the same name | Excel Discussion (Misc queries) | |||
Linear Mode
