I have recently completed converting a cumbersome Lotus DOS report to a
modern, macro machine... I am eager to share individual summary worksheets
from a very large workbook with individual users, but am having difficulty
determining the BEST (and easiest!) way to: 1) share the location summary
for separate locations among small groups
2) Ensure integrity of the source document.

Linking the destination files, with all protection still allows users to
'open source' when updating links.( I would need to establish file
permissions to allow users to update links anyway, which would also allow
users into the source in our server environment...) Any good ideas?