Difference between revisions of "Documentation/FAQ/Calc/Miscellaneous/How can I use cells from different Calc files?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
(New page: {{DISPLAYTITLE: How can I use cells from different Calc files?}} <section begin=question/> '''How can I use cells from different Calc files?''' <section end=question/> <section begin=ans...) |
m |
||
| Line 7: | Line 7: | ||
<section begin=answer/> | <section begin=answer/> | ||
# Open the source file | # Open the source file | ||
| − | # Select the cells and press | + | # Select the cells and press {{key|CTRL|C}} to copy them to the clipboard |
# Open the target file | # Open the target file | ||
| − | # Select a target cell and select | + | # Select a target cell and select {{menu|Edit|Paste Special}} from the main menu |
# Check the '''Link''' box in the '''Options''' section | # Check the '''Link''' box in the '''Options''' section | ||
Latest revision as of 14:49, 6 October 2021
How can I use cells from different Calc files?
- Open the source file
- Select the cells and press CTRL + C to copy them to the clipboard
- Open the target file
- Select a target cell and select Edit → Paste Special from the main menu
- 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.
