Formula

[h]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[h]

Excel 2003

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


Gord Dibben MS Excel MVP

 

[h]

Excel 2003

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


Gord Dibben MS Excel MVP

 

[Dave Peterson]

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.

 

[Gord Dibben]

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 Tools>Options>Transition>Save Excel files as: setting.


Gord