corrupt formulas

[Melissa G]

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
Mel

 

[Dave Peterson]

Rebuild the workbook/worksheet from scratch?

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
Mel

 

[Peter Huang [MSFT]]

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: <[email protected]>
Date: Thu, 09 Oct 2003 20:29:17 -0500
From: Dave Peterson <[email protected]>
Reply-To: (e-mail address removed)
X-Mailer: Mozilla 4.78 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: corrupt formulas
References: <[email protected]>
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!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:422710
X-Tomcat-NG: microsoft.public.excel.programming

Rebuild the workbook/worksheet from scratch?

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
Mel