Excel 2007 : Wrapped Text not showing up

[tpedry]

I have created a workbook with several sheets in it. Between the "Fixed estimate" and the "fixed worksheet" I have linked cells that are text wrapped. I enter in the text on the fixed estimate sheet, but when I go to the fixed worksheet, there is only one line showing and the text does not wrap. However, if I save and close the file, then reopen it the text wrap is working like it is supposed to on the second page. After seeing this, I tried selecting the cells that would not wrap on the second page and then go up to the format drop down menu and selecting "general". This also does the trick! So i think I have a formatting issue and I would like to have my formula take care of this problem or something that is automated. Does anyone know the answer to this problem? By the way, why does text wrap suck so bad in Excel, it seems like such a simple feature that would be used constantly!!!!!!!