some computers are on the same network, some in remote areas.
I do not want to have the warning message to be displayed, I want the links
to be self contained within the workbook. People using these workbooks have
no or little knowledge of excel spreadsheets, and how to change
fields,parameters,links or formulas. They will just be entering data in the
non-protected fields for reporting data. All the links point to sheets within
the workbook. So when the workbook is copied the links are not modified
pointing to where the files were. I hope this is enough info, thanks

"FloMM2" wrote:

Need more info:
Are computers on same network?
Where are the files located?
In a nutshell, on the new computer that files are copied to, when the file
is opened, you should get a warning about "Links". You can edit them at this
time to keep them intact.
HTH
:-)

"acomputer4u" wrote:

When I copy a workbook from one computer to another, the copied workbook
links still refer to the original. How do I set up or copy the workbook while
keeping the calculations within the same workbook?