How can I use cells from different Calc files?

From Apache OpenOffice Wiki
Jump to: navigation, search


How can I use cells from different Calc files?


  1. Open the source file
  2. Select the cells and press CTRL+C to copy them to the clipboard
  3. Open the target file
  4. Select a target cell and select Edit - Paste Special from the main menu
  5. Check the Link box in the Options section

The inserted data are now linked to the original document. Whenever the data changes in the source document this will be reflected in the target document.


Personal tools