Hi,

Yes, I think there was some corruption. I modified your approach by using a
new workbook and copying all the sheets using the steps you provided. And
then I had to adjust the links.

Thanks.


"CaptainQuattro"
<CaptainQuattro.28egka_1148621700.8263@excelforu m-nospam.com wrote in
message news:CaptainQuattro.28egka_1148621700.8263@excelfo rum-nospam.com...

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