I work in Excel 2007, but a number of my coworkers have Excel 2003. I need to send out a daily Excel file to them. For about three months now I have had a file that I originally made in compatibility mode. I have no idea what happened, but the file no longer saves ANY formatting. The formatting that is lost includes the following: highlighting, bold, underlining, date format, dollar format and percentages (possibly other items that I can't pinpoint currently). My Excel file still 'works' in that the information is still there and my pivots still update, but I can't send it out to everyone. Not to mention since dates are an important part of this file, it is eating up my time each day to work in it, because to start with I have to go in and format the dates and dollars. I'm not good enough to read dates as five digit numbers yet I made a test file where all I do is random formatting and save, and it works A-OK. So I started just recreating my base file, thinking it was an issue with the file. Well I save as I go, and I can get to a certain point with all formatting in place, but I hit a point where I save and all formatting is lost. I've attempted recreating in different orders, and it doesn't lose formatting on a certain bit of information, so I'm not sure if it's a size issue with the file or what. I have pivots in my old file, but I haven't gotten to the point of creating them in the new file, so I don't think pivot tables are the issue. I don't know how to even troubleshoot at this point.