Tracking changes on a spreadsheet

Resolved · High Priority · Version 2003

Dianne has attended:
Excel Intermediate course

by - delegate Dianne [5 posts] (2008 Jun 30 Mon, 14:51) Reply

I share a spreadsheet with someone over seas who is forever changing figures on my side of our intercomapny, i have forgotten how to go about reviewing all the changes made to the sheet when i recieve it back rathe than re-reconcille the whole thing!!

PLease help!

Dianne

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Tracking changes on a spreadsheet

by - trainer Katie gold contributer [214 posts] (2008 Jul 1 Tue, 12:06) Reply

Hi Dianne,

Thank you for yor question.

To track changes on Excel 2003, you will need to switch on the feature on TOOLS menu > Track Changes > Highlight Changes.

In the Highlight Changes window, you may choose to review a particular user's changes then on the spreadsheet you can choose to accept / reject each individual changes.

All changed cells are highlight with a dark blue tag.

Hope this is useful.

Kind regards,

Katie Woo
Microsoft Certified Trainer

· Prepare for your MOS Certification with MS Excel Courses
· Do You Really Need Excel VBA Training?
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
excel training and other Microsoft training courses.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Rate this page: