I have a spreadsheet document with many sheets, with numerous references between them. (The design is mandated by the outfit I do the work for). I would like to be able to copy some or all of the sheets into another document, and have any formulas that link between them refer to the new location. As things stand, they refer to the (now remote) original document.
Is there a way?
The same problem. When copy sheet to a new ods file the links to external cells of another ods file are not preserve.
Copy all relevant sheets together in one action. Open the target document, then in the source document select the sheets to be copied, i.e. with Shift+Click for a range of sheets or Ctrl+Click for individual sheets, then menu Sheet → Move or Copy Sheet…, Action Copy, Location To document select the target document, Insert before choose sheet or - move to end position -.
This does the copying, but does not preserve links between the copied sheets. Those links now refer back to the originals.