I have a sheet that is corrupting or not saving formulas.
Sometimes it is fine for a day or two but then I open it
up and the formula cell references are off or they are
gone completely.

This is a shared spreadsheet that has only recently
started exhibiting this problem. any way to correct this
type of corruption? any ideas at all?

thank you in advance :D
Mel

Rebuild the workbook/worksheet from scratch?



Melissa G wrote:

I have a sheet that is corrupting or not saving formulas.
Sometimes it is fine for a day or two but then I open it
up and the formula cell references are off or they are
gone completely.

This is a shared spreadsheet that has only recently
started exhibiting this problem. any way to correct this
type of corruption? any ideas at all?

thank you in advance :D
Mel

--

Dave Peterson

Hi Melissa,

Here is a KB link about the corrupted issue ,you may have a try.
179871 XL2000: Methods for Recovering Data from Damaged Workbooks
http://support.microsoft.com/?id=179871

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
Message-ID:
Date: Thu, 09 Oct 2003 20:29:17 -0500
From: Dave Peterson
Reply-To:
X-Mailer: Mozilla 4.78 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: corrupt formulas
References:
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: 1cust112.tnt1.belvidere.il.da.uu.net 67.195.89.112
Lines: 1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:422710
X-Tomcat-NG: microsoft.public.excel.programming

Rebuild the workbook/worksheet from scratch?



Melissa G wrote:

I have a sheet that is corrupting or not saving formulas.
Sometimes it is fine for a day or two but then I open it
up and the formula cell references are off or they are
gone completely.

This is a shared spreadsheet that has only recently
started exhibiting this problem. any way to correct this
type of corruption? any ideas at all?

thank you in advance :D
Mel

--

Dave Peterson