close

My coworkers and I often are working on the same document at the same time.
I would like to find a way to share the excell sheet between the 3 of us so
that we can immediatly see changes posted by the others, with out having to
use livemeeting or anything like that. The last place I worked had an excel
spreadsheet like that where all the QC techs would have thier own sheet and
the master report sheet would update in real time. Well maybe not real time
but twice a minuet or something. I would like something like this where I do
not have to merge everyones sheet at the end of the day. Also so my
supervisor at any time can pull up that file and see where we are in our
workload. Does anyone have any Ideas?

Thanks everyone for the help.

Kevin

Tools|share workbook

But there are lots of things that don't work in shared workbooks.

And there's an Advanced tab that gives you a couple of options when your version
should get updated.

Kanaski79 wrote:
gt;
gt; My coworkers and I often are working on the same document at the same time.
gt; I would like to find a way to share the excell sheet between the 3 of us so
gt; that we can immediatly see changes posted by the others, with out having to
gt; use livemeeting or anything like that. The last place I worked had an excel
gt; spreadsheet like that where all the QC techs would have thier own sheet and
gt; the master report sheet would update in real time. Well maybe not real time
gt; but twice a minuet or something. I would like something like this where I do
gt; not have to merge everyones sheet at the end of the day. Also so my
gt; supervisor at any time can pull up that file and see where we are in our
gt; workload. Does anyone have any Ideas?
gt;
gt; Thanks everyone for the help.
gt;
gt; Kevin

--

Dave Peterson

So if I put this on a computer that everone can access on the network, all of
us can open that sheet and modify it?

Thanks for the response.

quot;Dave Petersonquot; wrote:

gt; Tools|share workbook
gt;
gt; But there are lots of things that don't work in shared workbooks.
gt;
gt; And there's an Advanced tab that gives you a couple of options when your version
gt; should get updated.
gt;
gt; Kanaski79 wrote:
gt; gt;
gt; gt; My coworkers and I often are working on the same document at the same time.
gt; gt; I would like to find a way to share the excell sheet between the 3 of us so
gt; gt; that we can immediatly see changes posted by the others, with out having to
gt; gt; use livemeeting or anything like that. The last place I worked had an excel
gt; gt; spreadsheet like that where all the QC techs would have thier own sheet and
gt; gt; the master report sheet would update in real time. Well maybe not real time
gt; gt; but twice a minuet or something. I would like something like this where I do
gt; gt; not have to merge everyones sheet at the end of the day. Also so my
gt; gt; supervisor at any time can pull up that file and see where we are in our
gt; gt; workload. Does anyone have any Ideas?
gt; gt;
gt; gt; Thanks everyone for the help.
gt; gt;
gt; gt; Kevin
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Yep.

But lots of people don't use excel for anything that requires simultaneous
updates. Just because of the trouble that they've had in the past.

If you really need concurrent updates, maybe Access would be better?

Kanaski79 wrote:
gt;
gt; So if I put this on a computer that everone can access on the network, all of
gt; us can open that sheet and modify it?
gt;
gt; Thanks for the response.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Tools|share workbook
gt; gt;
gt; gt; But there are lots of things that don't work in shared workbooks.
gt; gt;
gt; gt; And there's an Advanced tab that gives you a couple of options when your version
gt; gt; should get updated.
gt; gt;
gt; gt; Kanaski79 wrote:
gt; gt; gt;
gt; gt; gt; My coworkers and I often are working on the same document at the same time.
gt; gt; gt; I would like to find a way to share the excell sheet between the 3 of us so
gt; gt; gt; that we can immediatly see changes posted by the others, with out having to
gt; gt; gt; use livemeeting or anything like that. The last place I worked had an excel
gt; gt; gt; spreadsheet like that where all the QC techs would have thier own sheet and
gt; gt; gt; the master report sheet would update in real time. Well maybe not real time
gt; gt; gt; but twice a minuet or something. I would like something like this where I do
gt; gt; gt; not have to merge everyones sheet at the end of the day. Also so my
gt; gt; gt; supervisor at any time can pull up that file and see where we are in our
gt; gt; gt; workload. Does anyone have any Ideas?
gt; gt; gt;
gt; gt; gt; Thanks everyone for the help.
gt; gt; gt;
gt; gt; gt; Kevin
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()