I try copy list from one site to another using template, but this list contains lookup fields. Is there any way copy lists without breaking this fields? I copy all lists which will be used for lookup links.An d another question, i have equal lists in two different site collections, i need update data in second list using first, how better do that?
Saving list as template will not keep the look up field connections.
- Restore Lookup Lists in Destination
- Save Master List as Template without data
- Restore Master List in Destination
- Fix Lookup fields
- Export source list into Excel
- Copy Rows from Excel
- Open Destination List in Data Sheet mode
- Paste data