master data workbook?

[Kimber]

I have many different reports and graphs that I create from many data sources. Most data is used for more than one report or chart, and historically, my predecessors entered the data into each report separately. Obviously, this increases the chance of human error and requires more steps for changes. I wonder what your thoughts are on creating a “master” data sheet/workbook and having the reports and charts linked to that one workbook. It makes sense to me, but perhaps I’m overlooking a reason not to set my reports up in this fashion. I appreciate suggestions.

 

[Luke M]

I agree with your idea about creating the master workbook. As long as there's no reason to keep teh data separate for security/privacy issues, it would certainly make things easier. You could then build separate reports that use Queries to get the relevant data that they need, or link directly.