Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Blair
 
Posts: n/a
Default how to update a shared workbook using the same cells at the same t

I have 5 to 10 users entering data by rows into a simple shared workbook.
There are different versions of excel but none older than excel 2000. Can
Excel allow users entering data into the same cells at the same time avoid
having to deal with the conflict resolution popup? For example 2 users are
inputting data into cells on row number 465 and they "save" at approximately
the same time. Excel than automatically allows the first save to populate
row 465 and populates row 466 with the second save? I managed to acheive
this result by having a co-worker hit the save button at the same time by
counting "one, two, three... now" if you can believe it. When I try saving
at my station, walking to another and saving i cannot emulate the same result
but get the conflict resolution window. Thanks all

Blair
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
linking cell value in one workbook to a cell in another workbook Jig Bhakta Links and Linking in Excel 1 January 20th 05 06:12 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM
How do I extract cells from multiple workbooks Trevor Excel Discussion (Misc queries) 1 November 25th 04 10:59 PM
copy\paste from one workbook to another Mark Excel Discussion (Misc queries) 0 November 25th 04 10:55 PM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"