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!