Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2011, 12:02 AM
eguru2 eguru2 is offline Shared Excel workbook Windows XP Shared Excel workbook Office 2007
Novice
Shared Excel workbook
 
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
Reply

Tags
document, shared

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to limit premissions in a Shared Excel Doc beb1227 Excel 0 05-24-2011 06:21 AM
Shared Excel workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
Unable to open Excel 97-2003 workbook J Partridge Excel 1 11-07-2010 03:26 AM
Shared Excel workbook Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM
Share Workbook cannot merge Ichigo Excel 3 01-19-2010 03:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft