Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas saving as values
Since I switched to Excel 2007, when I open a workbook that had formulas in
it, they are displaying as values instead. I want to keep the formulas. I've looked for an option for this in Excel Options, but haven't found one. Does anyone know what's causing this to happen and how I can stop it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas saving as values
Your problem is not clear...
Are you losing the formulas which are getting replaced by values? Pl. give an example... "Fun Dan" wrote: Since I switched to Excel 2007, when I open a workbook that had formulas in it, they are displaying as values instead. I want to keep the formulas. I've looked for an option for this in Excel Options, but haven't found one. Does anyone know what's causing this to happen and how I can stop it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas saving as values
Yes. Exactly. Workbooks that had formulas previously now show just values
when I open them in Excel 2007. It's as if I copied the values over the formulas, but I didn't. "Sheeloo" wrote: Your problem is not clear... Are you losing the formulas which are getting replaced by values? Pl. give an example... "Fun Dan" wrote: Since I switched to Excel 2007, when I open a workbook that had formulas in it, they are displaying as values instead. I want to keep the formulas. I've looked for an option for this in Excel Options, but haven't found one. Does anyone know what's causing this to happen and how I can stop it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas saving as values
I have not faced this problem. You should be getting a prompt at the time of
opening the file... Can you send the file to me? id to_sheelo add @hotmail.com "Fun Dan" wrote: Yes. Exactly. Workbooks that had formulas previously now show just values when I open them in Excel 2007. It's as if I copied the values over the formulas, but I didn't. "Sheeloo" wrote: Your problem is not clear... Are you losing the formulas which are getting replaced by values? Pl. give an example... "Fun Dan" wrote: Since I switched to Excel 2007, when I open a workbook that had formulas in it, they are displaying as values instead. I want to keep the formulas. I've looked for an option for this in Excel Options, but haven't found one. Does anyone know what's causing this to happen and how I can stop it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
Saving Formulas when addin rows | Excel Discussion (Misc queries) | |||
How do I keep formulas for being lost when saving in 2007? | Excel Discussion (Misc queries) | |||
Saving formulas in a worksheet so that..... | Excel Discussion (Misc queries) | |||
Saving templates with links and formulas | Excel Discussion (Misc queries) |