Formula

  • Thread starter Thread starter h
  • Start date Start date
H

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
 
What version of Excel and what format are you saving the workbook as?


Gord Dibben MS Excel MVP
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to calculate hrs flown in last one year 0
Formula problems 2
Cell showing formula instead of date 6
excel cells changing to "#VALUE!" whenever another file is opened 8
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel 2003 worksheet doesn't auto calculate 4
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formulas not copying to other cells 10

Back
Top