ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking Question (https://www.excelbanter.com/excel-discussion-misc-queries/58266-linking-question.html)

southpaw3229

Linking Question
 

We have a excel file (it's our Budget) it is uploaded in a folder on the
company share drive (server).

Each department needs to be able to make changes to their section of
the budget(each department has their own sheet in the workbook).

My question is can they have their sheet on their PC, make changes and
hit an upload button that makes the change on the budget that is on our
server.

I don't want people to just copy the workbook to their PC and make the
changes and then upload their refresh copy to the server, b/c somebody
at the same time could be doing the same thing and their work might not
get updated.

How can i make this happen?

thanks


--
southpaw3229
------------------------------------------------------------------------
southpaw3229's Profile: http://www.excelforum.com/member.php...o&userid=29263
View this thread: http://www.excelforum.com/showthread...hreadid=489931


Eddie O

Linking Question
 
You may want to check out http://www.groove.net/
Microsoft just purchased this company, and it allows multiple users to
collaborate on a single document, including speadsheets. I believe it's free
use.

"southpaw3229" wrote:


We have a excel file (it's our Budget) it is uploaded in a folder on the
company share drive (server).

Each department needs to be able to make changes to their section of
the budget(each department has their own sheet in the workbook).

My question is can they have their sheet on their PC, make changes and
hit an upload button that makes the change on the budget that is on our
server.

I don't want people to just copy the workbook to their PC and make the
changes and then upload their refresh copy to the server, b/c somebody
at the same time could be doing the same thing and their work might not
get updated.

How can i make this happen?

thanks


--
southpaw3229
------------------------------------------------------------------------
southpaw3229's Profile: http://www.excelforum.com/member.php...o&userid=29263
View this thread: http://www.excelforum.com/showthread...hreadid=489931




All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com