What is the wording in the macro where the data is pasted in the new
Workbook? A change there might be what is needed.


--
Best wishes,

Jim


"MDW" wrote:

My department uses an Excel workbook with macro-driven calculation and
modeling. The file is called Model.xls. The model has links to two external
input files, also Excel workbooks.

After the model is done calculating, it creates an output file by saving
itself as output_Model.xls and then copying each worksheet and pasting the
values. This process has been in place for years and we haven't experienced
any problems with it.

What we've discovered is that this output file has a link listed under the
"Edit - Links" menu. Strangely enough the link isn't to either of the input
files, but rather to the file "Model.xls". I can't locate any cells that
actually reference this link - as I said, the final step in the creation of
the output file is to copy/paste values on each sheet.

Does anyone know how that link could have gotten there? It appears to be on
every output file I can locate. It seems completely benign, but I'm just
curious as to what process would have caused it to happen in the first place.
As a bonus, if anyone has any suggestions for how we can prevent it from
happening, that would be great as well.
--
Hmm...they have the Internet on COMPUTERS now!