Multiple "source" workbooks linked to single "destination" workboo

D

DAVEJAY

I have created multiple workbooks that are being used by 8 different users.
I have the cells in each source workbook linked to the destination workbook.
(Note: the destination workbook is on a company server.) I've read several
posts here and I think I may be having a "path" vs. formula issue. When a
user updates his/her source workbook and goes to save it on the desktop, the
destination workbook on the server does not update. Also, I have tried
putting all of the workbooks (source & dest.) on the server so we can all
just go there and get the work done. It will not allow the user to save his
workbook unless he chooses another name. Any ideas this is driving me nuts!
 
C

Charles Williams

I dont think you can make this work properly the way you want with the
design you have.

You need to have a central something that contains the data and handles
updates by multiple users.
This should really be a proper database (Access or SQL Server for instance),
but you might be able to get away with a shared Excel workbook, depending on
how frequent the updates and useage are. Then the users workbooks read the
central db/shared workbook.

Other wise you could use a batch process: the users have independent
workbooks which they email or sahre periodically and them the central
workbook is opened to get the data from the independent workbooks.

But my advice would be to go for a proper database solution with an Excel
front-end.

regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top