why wont a formula save?

[MichelleD]

I have 6 spreadsheets and have been trying to save a formula in the same cell
in all 6 spreadsheets but when I save and close out, its not there the next
time I use it, any ideas on why?

 

[Bernard Liengme]

Tell us more about the steps you are using

 

[jlclyde]

I have 6 spreadsheets and have been trying to save a formula in the same cell
in all 6 spreadsheets but when I save and close out, its not there the next
time I use it, any ideas on why?

Are you opening as read only? Does the sheet say Read Only in teh
Blue bar at the top? Is someone saving back over your info? Try
changing Tools/Options/calculation to automatic.

Jay

 

[MichelleD]

It was already in automatic. Is it possible that its a dead cell? if so can I
just delete one cell?

 

[MichelleD]

Also, its not a read only and no one else is sharing this spreadsheet.

 

[Mike H]

Hi,

I don't understand the concept of dead cell. Try this:-

In windows explorer navigate to the workbook and note the date/time last
modified values.
Open your workbook and change somthing and save
re-check the date/time modified, has it changed?

Mike

 

[dlw]

Is there maybe an autoexec macro or some vb code that overwrites the cell
when you open the sheet?