This sounds like a Worksheet Design problem.

Can you save the workbook as an Excel 2003 (xls) file and post it?