View Single Post
 
Old 07-12-2011, 12:02 AM
eguru2 eguru2 is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2011
Posts: 1
eguru2 is on a distinguished road
Default Shared Excel workbook

Hi,

I know I am opening a can of worms and this has probably been discussed before but here goes.

I would like to use the Share document feature in Excel 2007 to enable several people to update a spreadsheet at the time. This is only to update cells in a spreadsheet. There is no inserting or deleting rows.

During testing I have been getting people to update 10-20 cells in the spreadsheet, save the spreadsheet and then exit. Once everybody has keyed their test data they exit.

I have set up the spreadsheet to track changes. When I view the changes all changes that have been made are recorded in the Change History, however not all changes appear in the spreadsheet. It appears that a block on changes from one of the uses (can be any) will not appear in the spreadsheet even though they are in the change history.

Am wondering if any body has had any expecience with shared documents and whether this is worth pursuing?

Thanks in advance for any help.
Reply With Quote