View Full Version : Automatically update master file to others
simonbashar
Jun 13, 2009, 06:22 AM
I have 5 files and one master file.I want to automatically update those 5 files when I
Input on master file.
ScottGem
Jun 13, 2009, 06:23 AM
You need to give us more details. Do you mean files or tables? What database platform are you working in? Why do you have multiple copies of a master? Any other details you think pertinent may also help.
simonbashar
Jun 13, 2009, 07:54 PM
I have a excel file name "order in hand".I made many reports by using "pivot report" in
That file.On the other hand I need 5 more copies because other 5 person use that file with different Pivot Report.
Usually I made 5 copies of "order in hand" and then made different reports and send to different person.This is time consuming.Now I want My "order in hand" sheet linked with other 5 (folders,files, drive),so that when I input any data on; it change/ update data with other 5. I will make various report for their need first time, than I refreshing report ant send it to them
Hope I clear my question to u.
ScottGem
Jun 14, 2009, 05:55 AM
Yes that helps. I've moved your question to the Spreadsheets forum since it's a spreadheet issue, not a database issue.
But there is one more question here. Do the 5 users you share this spreadsheet with have access to a shared drive on your LAN? If not, there is nothing else you can do to automatically have their copies update.