Without seeing a workbook containing the originals, and another with the problems, it's difficult to be sure what the issues are.

1. Probably because copying & pasting loses the window splitting that applied to the original.
2. Usually happens when the source has references to another worksheet. You can fix this using Find/Replace to delete the unwanted workbook references.
3. You need to make sure the worksheet the reference table is on has the same name as in the original workbook, or change the sheet references in the formulae. You also need to make sure the reference table is in the same rows & columns as before.

There may be other issues, but without seeing the workbooks, it's hard to say.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]