Or Excel Programming

[Guest]

the question here is, if i'd want to share or have some what of a live feed
with two user in a network... eg. we have a network and i save a file there,
now i want to update that file by saving it, but i can't because you have the
file open you'd have to close it first. the question here is, is there a way
where i can somehow update the file without you having to close it in order
for me to update it?

 

[Gord Dibben]

You can share a workbook under Tools>Share Workbook.

Both users can have it open for editing at the same time.

For more info including some features that not available with shared workbooks
see help on "shared workbooks" and "troubleshooting shared workbooks"

Shared workbook:

A workbook set up to allow multiple users on a network to view and make changes
at the same time. Each user who saves the workbook sees the changes made by
other users. You must have Excel 97 or later to modify a shared workbook..


Gord Dibben MS Excel MVP