Multiple accessing of an excel file
 

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

Multiple accessing of an excel file
 

What you want is a shared workbook.

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

--
Marc.


" wrote in
oups.com:

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

Multiple accessing of an excel file
 

You could share it. ToolsShare Workbook, although it restricts
functionality and can cause problems.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
oups.com...
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

Multiple accessing of an excel file
 

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" wrote in message
...
You could share it. ToolsShare Workbook, although it restricts
functionality and can cause problems.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
oups.com...
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

Multiple accessing of an excel file
 

"Ken Wright" wrote in message
...
Shared workbook = Keep backups - Lots of backups!!!!!!


and expect loss of functionality, and buckets of tears

Multiple accessing of an excel file
 

with lots of swearing thrown in for good measure :-)

"Bob Phillips" wrote in message
...


"Ken Wright" wrote in message
...
Shared workbook = Keep backups - Lots of backups!!!!!!


and expect loss of functionality, and buckets of tears