View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Poof! formula gone

The two most likely explanations a

1. You didn't save it. It happens, you think you click "OK" but actually
click "Cancel" or something of that nature.

2. You did save it, but with a different file name and/or different
location. And what you're looking at now is the old file.

HTH
Elkar


" wrote:

While working on a spreadsheet, I placed all these nice little formula's in
it and they all worked wonderful. Saved and closed the worksheet. Life is
grand. Open it the next day and the formula's are all gone. The protect
worksheet is not on. The cell is not formated to make it hidden either.
What did I do? Thanks for any and all light that you can shed on this isse.

Oh I am using ...Vista SP 1 for an OS and Excel 2007..and advil...lots and
lots of advil. Starting to wonder about some Jack to wash it down with too.