Excel 2007 : Excel compatibility issues from 07-03

You wrote:

All others bar one that need access to the file are working in 03. They've all downloaded the latest compatibility file. however when they open my file it states that there are too many formated cells and then procedes to take all the formatting out and a bunch of different sheets.

Does it literally take out a bunch of different sheets, or does it take out the formatting on a bunch of different sheets?

If it's deleting sheets, then I've got no ESH to share .

On the other hand, if you are just losing the formatting, a quick test might be to make sure you are using no colors or formatting techniques that aren't available in Excel 2003. If you are using the same colors and formats as the 2003 version of your spreadsheet and you are still seeing the problem, your .xlsx (or .xlsm) may somehow have become corrupted (not something I've personally experienced, but have seen references to it occurring).

I'm not sure of how to deal with a corrupt workbook, but my guess is that you would have to load up a 2003 version, save it as a 2007 version and re-do any mods you made...

James