 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2007Multiple "source" workbooks linked to single "destination" workboo
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! 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 >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 [quoted text clipped - 10 lines] > workbook unless he chooses another name. Any ideas this is driving me > nuts! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.