Multiple accessing of an excel file

[s_aboobaker]

Hey people,

My problem is that I ahve an excel file that both my collegue and
myself need to update constantly, however the problem is that in order
for me to access it and update it he needs to get out of it and vice
versa. Is there any way Excel would allow us to access it toegther and
update it together, without one of u having to come out of it.


Thanks

 

[Marc Fleury]

What you want is a shared workbook.

Tools | Share Workbook, check the "Allow changes by more than one user at a
time" box.

 

[Bob Phillips]

You could share it. Tools>Share Workbook, although it restricts
functionality and can cause problems.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Shared workbook = Keep backups - Lots of backups!!!!!!

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Bob Phillips]

Shared workbook = Keep backups - Lots of backups!!!!!!

and expect loss of functionality, and buckets of tears

 

[Ken Wright]

with lots of swearing thrown in for good measure