Can't find in 2007

**NewToExcel-2007** · 09-05-2010, 04:13 PM

On old versions of Excel I was able to generate a master Workbook and give copies to others to work on.
Then at the end of the day I was able to update the master or syronize the master with what was changed in the copies.

I do not know what this is called and I am having problems finding it in the help files of 2007.

Does 2007 have this feature?
What is it called?
How does it work?

**MarvinP** · 09-05-2010, 04:20 PM

Are you sure that wasn't Microsoft Access?

**NewToExcel-2007** · 09-05-2010, 04:23 PM

See how much I for get.
Ya, It may have been.

Anyone else know of this option.

**Richard Buttrey** · 09-05-2010, 04:33 PM

Hi,

The functionality you describe is to be found in 2007 ribbon's Review tab. Look in the 'Changes' section and use the 'Share Workbook' icon.

It works in much the same way as the previous 2003 version.

HTH

**MarvinP** · 09-05-2010, 04:35 PM

Access has a way of locking records or telling when a field was updated. Excel doesn't have this feature.

Depending on how much data is added or updated, and how few people you distribute it to, there are possible methods.

I've seen on this site a way to background color every cell that has been updated. If you had only about 5 people working on your "copies" and got them back at the end of the day and nobody had changed the same cell .....

You see the problem.

**MarvinP** · 09-05-2010, 04:42 PM

Hi Richard,

I stand corrected and am now reading about "Use a shared workbook to collaborate" found in the 2010 Excel help file.

At the bottom of the help file is a section on "Resolve conflicting changes in a shared workbook" as I was expecting.

I'm more amazed everyday with what Excel can do. Add one more amazement to the list.

And I hate being wrong!!!! I guess we all learn from this site. Thanks Richard!

**NewToExcel-2007** · 09-05-2010, 07:20 PM

Ok
This is what i did.
I created a new Workbook with different data on 4 worksheets.
I went to review tab and followed the instruction for sharing the workbook.
I opened from file open the same document three times therefore having the same document opened 4 times
I went to each Workbook File and edited a different worksheet in each workbook file.
I saved each workbook.
I opened the workbook file one more time. therefore I had the same workbook opened 5 times at the same time.
the most recent file had allthe changes made to it that was made in the previous opend files.

You must save as you do your changes.
To see what others have done you must close and reopen the file.

Did anyone else try this out?