General discussion

Locked

Highlight Changes in an Excel 2000 Workb

By bill ·
I receive an Excel 2000 Workbook each week from a vendor with 7-10 worksheets, printed about 50 pages. I would like to be able to quickly tell, perhaps by highlighting, what has changed, be it added or deleted rows, changes to amounts, etc. The columns always stay the same but each worksheet could have from one row filled out to many depending on the project.

The vendor is not currently willing to highlight these changes for me.

Do I need to be looking at a 3rd party compare program or does excel already have this capability.

My reason for wanting all this is I also use this vendor provided workbook as the source data to links in a worksheet of my own. When they delete a row my worksheet gets a #REF (I think it is), but I can't tell when they added a row to their workbook. I want to know this so I can set up my links to the workbook.

And I would like to know which cells in my worksheet have changed that I am already linked to since the last update.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Highlight Changes in an Excel 2000 Workb

by LeighR In reply to Highlight Changes in an E ...

Have you tried using the track changes feature located in the TOOLS menu? If you give the workbook to the vendor with track changes feature enabled you will be able to do this.

You also should enable track changes in your own worksheet so you can find the changes faster.

Collapse -

Highlight Changes in an Excel 2000 Workb

by bill In reply to Highlight Changes in an E ...

Poster rated this answer

Collapse -

Highlight Changes in an Excel 2000 Workb

by DKlippert In reply to Highlight Changes in an E ...

Shareware solution
www.synkronizer.com/

You can download a free file called compare

www.cpearson.com/excel/download.htm

Use a 3rd workbook

http://makeashorterlink.com/?E29313671

This one is for Excel 97, I have not tried it with 2000

www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm

Collapse -

Highlight Changes in an Excel 2000 Workb

by bill In reply to Highlight Changes in an E ...

Poster rated this answer

Collapse -

Highlight Changes in an Excel 2000 Workb

by bill In reply to Highlight Changes in an E ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums