Excel 2007
 

I use Excel 2007 to create spreadsheets that I then email out to coworkers,
some of whom use Excel 2007 and some of whom use Excel 2003. I normally
copy the rows my coworkers need into a new spreadsheet and save it in Excel
97-2003 format. The problem is that absolutely ALL formatting is stripped
from the spreadsheet, right down to bolded text and borderlines.

I've tried reopening the spreadsheet in compatibility mode and replacing the
formatting, but it gets stripped out again. I've also tried sending out a
version of the spreadsheet in the regular Excel 2007 format (*.xlsx) and
having my coworkers download the compatibility package. They still can't see
the formatting. Also, some of my coworkers have reported errors of, ""Excel
encountered an error and had to remove some formatting to avoid corrupting
the workbook. Please re-check your formatting carefully," no matter which
version of the file they try to view.

I'd welcome any suggestions that could help me resolve this issue.