How can I update 2 or 3 duplicate workbooks in separate folders?

[LindaK]

I have several workbooks kept in different folders and would like all of them
to update when I make changes without having to go in and change all of them.
Is there a way to link them or can I run a macro that does them all at once?
Thank you in advance.

 

[Joel]

My first question is why do you have duplicate workbooks? The best way of
copying duplicates workbooks would do copy the files when the workbooks are
closed and not being used.

I think you have duplicate workbooks becuase you have multiple users making
changes at the same time and somebody relized that shared workbooks create
problems. Well duplicate workbooks have the same problems.

Your problem is that you shouldnt be storing the data in excel but in Access
or some other database program. The best solution is to have the users work
in excel but have the data stored in a database program. You can use excel
as a front end application put hav the data stored in the database.