I don't know what's happening with the Excel5 save, and (as you point out) the formatted circle is lost when saving using Excel2007. I have no idea why, and any solution is going to take months rather than hours. suggest you use COM instead to handle this
complex formatting, especially as your workbook also contains macros.