Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Seattle, Washington, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disappearing formulas (2003/SP2)

    I have an Excel workbook some of whose cells contain formulas (functions). Last evening and again this morning (rebooting in-between), the formulas are gone, and in their place are empty cells. Is this an anomaly or a known issue with Excel? Can I protect against it?

    Thanks in advance,
    Erik

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disappearing formulas (2003/SP2)

    Did the worksheet become protected? (Check in Tools | Protection)

    Do you have a good backup of the workbook - that is the best insurance against corruption.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Seattle, Washington, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing formulas (2003/SP2)

    ...and they've just disappeared again...I think all I did was Save. I'll experiment some more and report back.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Seattle, Washington, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disappearing formulas (2003/SP2)

    Please disregard this problem. My mistake. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Sincerely,
    Erik "Think Before You Post" Schwab

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •