Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
andy
 
Posts: n/a
Default Shared workbook - one at a time?

We are using Excel (office 2000), and have Shared and
protected a workbook. The file is also password protected
for modifications. When one person is in the workbook
modifying the file, the next person attempting to enter
the file is presented with a dialog box that says who is
already in the file. The new user can then choose to be
notified of when the current person modifying is through,
or they can enter as read only. Is this the way it is
supposed to work?

I thought that as shared workbook would allow more than
one person to be in the workbook and to modify?

Please explain, and if there are options to have more than
one person in, and doing modifications please point me to
where I can find out about this.

Thanks in advance
  #2   Report Post  
Gordon
 
Posts: n/a
Default

andy wrote:
We are using Excel (office 2000), and have Shared and
protected a workbook. The file is also password protected
for modifications. When one person is in the workbook
modifying the file, the next person attempting to enter
the file is presented with a dialog box that says who is
already in the file. The new user can then choose to be
notified of when the current person modifying is through,
or they can enter as read only. Is this the way it is
supposed to work?

I thought that as shared workbook would allow more than
one person to be in the workbook and to modify?


Would YOU be happy working on a workbook with the knowledge that someone
else was mofiying things which you had no control over? I know I
certainly would NOT!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk
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
Shared workbook protection zeek Excel Discussion (Misc queries) 1 December 13th 04 02:30 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM
Problem with shared workbook (history sheet) ACH Excel Worksheet Functions 2 December 9th 04 09:39 PM
Scroll Bar in Shared workbook Ronil Patel Excel Discussion (Misc queries) 2 December 8th 04 02:49 AM
how to update a shared workbook using the same cells at the same t Blair Excel Discussion (Misc queries) 0 November 26th 04 11:21 PM


All times are GMT +1. The time now is 10:20 PM.

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"