software

I have multiple problems.

I am attempting to quot;linkquot; multiple spreadsheets together with external
references to a main Excel workbook that contains all of my data and protect
the worksheets/workbooks so that others can use (enter data) these
spreadsheets without damaging formulas, etc. Once I complete the
quot;templatesquot;, I am emailing them to other locations for use. The templates
work fine on my computer.

Multiple problems are occurring:
1) Links are not maintained between the spreadsheets when they are received
on the other end. With the spreadsheets quot;protectedquot;, they cannot quot;re-linkquot;.
I understand that the spreadsheets need to maintain the same name and should
be kept in the same folder location but without giving the person the
password to quot;unprotectquot;, they are unable to quot;relinkquot;
2) When they return the files to me via email, the worksheet is still
attempting to reference the original spreadsheet (even though it shows
external source is not found in the links dialogue box). When I attempt to
break this link and quot;change sourcequot; to the newly downloaded version, I get
error messages saying that the report is quot;protectedquot;. In order to relink, it
appears EVERY worksheet in both reports must be quot;unprotectedquot; in order to
relink.
3) When I do quot;change sourcequot;, it appears to be attempting to keep the
original file AND the new source file linked. When I try to quot;break linkquot;
with the original in this situation, I get an error message saying that the
cells I am trying to change, etc. ,etc., are protected....

Is there an easy workaround to this problem?
Is there a way to quot;unprotectquot; multiple worksheets at one time?
Is there a way to quot;relinkquot; workbooks without unprotecting them?
Is there an easier way to quot;dumpquot; the data (or parts of it) into another
workbook -- something the end user can perform that is fail safe?

Thanks!