Excel 2007 : Track Changes

[flisters]

I'm trying to use the track changes funtion to track the changes of a weekly speadsheet that I send out for updates. My co-workers make the necessary changes and return to me.

I've tried two different approaches, to no avail: 1) Created the spreadshed, turned on "track changes", save, and sent out. Co-workers make the changes and send back but the changes aren't highlighted. 2) Created the spreadsheet and saved to a server, all co-workers make changes to the SAME document. Still didn't work. I selectect Track Changes When: Since last time I saved and Who:everyone but me.

Any insight would be greatly appreciated!

Thanks

[SCLai]

Sorry.. not that I am good with this, but for saving a xls in a server and be able to view changes, you may wan to put it to share [Tools>Share Workbook, under the 1st tab, check the only check box] since I think only a shared file will enable you to view changes. Only the changes made after you put it to share will be viewable.
A file that had been put to share has the suffix "[Shared]" for its window name.

Hope this will help to a certain degree!