Best practice for managing updates w/in distrubted workbooks?

[Mike G - DC]

Folks – What is the best practice for managing changes to the metadata
supporting workbooks? I have a workbook that contains a few frames, named
ranges, etc. The workbook will be distributed to roughly 50 to 100 users.
Unfortunately, we are not able to use Access or some form of shared network
drive. Each user will have their own instance of this workbook stored locally
on their workstation. What would the best practice be for managing updates
to the workbook after distribution to the end user?

For example, I’m thinking of placing all of my lists/named ranges in one
worksheet called “listsâ€. The logic being that as lists are updated, I can
somehow send the worksheet to each end-user asking them to copy/paste or
otherwise overwrite the data on the “lists†worksheet within their workbooks.
Is there a better way to seamlessly update this information? Furthermore, is
there a solid practice for updating the code within modules and frames? I
suppose I’m looking for the most efficient method of updating the things that
make the workbook sing and dance with the least amount of manual input from
the end user.
Any advice is much appreciated,

- mike

 

[Mike G - DC]

James - that is good advice. My users will be adding data within the
workbook, either via a form or directly within a worksheet. Maybe I can work
some type of import process into the workbook thereby giving the user the
ability to import their data into updated versions. This gives me something
to think about.

thanks, mike