View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fun Dan[_2_] Fun Dan[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?