You might also consider whether or not you can use READ ONLY files / filegroups for the data they are reporting on. And if you can get rid of Excel by using SSRS Report Builder for the end users (which gives them the power but doesn't do the same sort of locking that Excel or Access does).

This sounds like quite a mess. You may need some help to straighten it out if they have the resources to hire another DBA.