Data Lost In Excel 2003

[janinep]

I am using Excel 2007 and have created a new report for one of our product departments. The deparment the report was created for uses excel 2003. When the managers in that department view the report, everything looks normal. When they filter the report (i.e.; by manager name), all the data and conditional formatting disappears and the cells are empty and white. The totals at the end of the rows become #VALUE errors. I have checked, and there is only 2 conditional formats in the entire report (I ran into that problem yesterday and corrected it). Today, I tweaked the report a little to add a MTD total for each agent, and ran into this problem. Any idea what may cause this? Thanks in advance and have a great day.

 

[mole999]

are you able to develop in 2003, i have had CF changes occur 2003 to 2007, maybe starting 03 would be better