Two workers on the same Excel sheet

  • Thread starter Thread starter Jeppe
  • Start date Start date
J

Jeppe

Hi,

Pretend the situation that one worker ( 'person x' ) have made update
in a Excel datasheet and send it to the worker of the administration
'person y' ). When 'person y' recieves the datasheet, he makes so
changes in the datasheet.

Two hours later 'person x' finds out some errors in the last datashee
he sent, updates it again and send it once again to 'person y'.

How can 'person y' import ( after confirming the changes ) the ne
changes made of 'person x' to his datasheet ( the first datasheet h
got )?

Thank
 
It depends.

Myrna Larson and and Bill Manville wrote an addin that compares two worksheets
on a cell-by-cell basis.

A1 is compared with A1. B99 to B99. If one of the users inserted (or deleted)
rows (or columns), then this cell-by-cell comparison breaks down.

Here's a link to the program (kept at Chip Pearson's site):
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

====
Someone once suggested this that might be useful.

Save each worksheet as a .CSV file. Then use a program that compares text files
(or even MSWord) to do the compare.

It might make things slightly easier.
 
Finding changes between versions like this isn't easily done. I wouldn't depend
on being able to do it.

But if your users can save the file to a network location, just make sure that
they update it independently--and consecutively, not concurrently.

Excel does have a feature that allows you to share a workbook, but lots of
things are disabled when you do this.
 
Back
Top