Something you may want to try:
Before attempting the following make a backup of you file and move it
somewhere safe.
Insert a new worksheet
Copy the entire "broken" worksheet to the clipboard
Paste Special Formulas to Cell A1 of the new worksheet.
If TRUE and FALSE work correctly on the new worksheet, copy and "Paste
special" the formats and column widths from the broken worksheet to the
new version.
Next, you will need to use Edit Replace (Or Ctrl-H) to Find all
references to the broken page on each of the other 2 worksheets, and
replace them with references to the new page.
Finally, you can delete the broken page and bestow its name on the new
version.
--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread:
http://www.excelforum.com/showthread...hreadid=545722