Calc Guide

2) Switch to the other spreadsheet (the process to do this will vary
depending on which operating system you are using).
3) Select the sheet (Savings Account) and then the reference cell
(F3).
Figure 250: Selecting the savings account reference cell
4) Switch back to the original spreadsheet.
5) Click on the green check mark on the input line.
Your spreadsheet should now resemble Figure 251.
Figure 251: Linked files
You will get a good feel for the format of the reference if you look
closely at the input line. Based on this line you can create the
reference using the keyboard.
Creating the reference with the keyboard
Typing the reference is simple once you know the format the reference
takes. The reference has three parts to it:
• Path and file name
• Sheet name
• Cell
Looking at Figure 251 you can see the the general format for the
reference is
=’file:///Path & File Name’#$SheetName.CellName
302 OpenOffice.org 3.x Calc Guide