I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet

What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 14:49:00 -0700, h wrote:

I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet

Excel 2003

"Gord Dibben" wrote:

What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 14:49:00 -0700, h wrote:

I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet

Are you saving as an Excel workbook *.xls

If not.....then what?

Might be you could try re-entering the formulas then copy the sheet to a new
workbook and save that, making sure you are saving as an Excel workbook.

Check your ToolsOptionsTransitionSave Excel files as: setting.


Gord

On Fri, 20 Jun 2008 17:05:00 -0700, h wrote:

Excel 2003

"Gord Dibben" wrote:

What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 14:49:00 -0700, h wrote:

I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet

Excel 2003

"Gord Dibben" wrote:

What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 14:49:00 -0700, h wrote:

I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet

And you're saving the file as a normal workbook (*.xls), right?

You're not saving it as a .CSV file or .Prn file. Both of these are plain old
text files. Only values are saved in these types of files.

h wrote:

Excel 2003

"Gord Dibben" wrote:

What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 14:49:00 -0700, h wrote:

I use formulas to calculate geomean,average and stuff.But if I re-open a
saved file, the formulas doesnt show up and only teh calculated values show
up.I have to re-enter the formulas again. is there any way to retain the
formulas entered in excel sheet



--

Dave Peterson