Linking to External Data

Apache OpenOffice 4.1 Calc Guide

Chapter 10: Linking Calc Data

< Previous Section

Next Section >

• Why Use Multiple Sheets?
• Setting Up Multiple Sheets
  • Identifying Sheets
  • Renaming Sheets
  • Inserting New Sheets
  • Inserting Sheets From a Different Spreadsheet
• Referencing Other Sheets in the Spreadsheet
  • Creating the Reference with the Mouse
  • Creating the Reference with the Keyboard
• Referencing Other Documents: Links to Sheets in Other Spreadsheets
  • Creating the Reference Using the Mouse
  • Creating the Reference with the Keyboard
• Hyperlinks and URLs
  • Relative and Absolute Hyperlinks
  • Creating Hyperlinks
  • Editing Hyperlinks
  • Removing Hyperlinks
• Linking to External Data
  • Using the External Data Dialog
  • Using the Navigator
  • How to Find the Required Data Range or Table
• Linking to Registered Data Sources
  • Viewing Data Sources
  • Editing Data Sources
  • Launching Base to Work on Data Sources
  • Using Data Sources in Calc Spreadsheets
• Embedding Spreadsheets
  • Object Linking and Embedding (OLE)
    • Other OLE Objects
    • Non-linked OLE Object
    • Linked OLE Object
  • Dynamic Data Exchange (DDE)
    • DDE Link in Calc
    • DDE Link in Writer

< Previous Page

Next Page >

Linking to External Data

You can insert tables from HTML (web) documents and data located within named ranges from an OpenOffice Calc or Microsoft Excel spreadsheet into a Calc spreadsheet. (To use other data sources, including database files in OpenOffice Base, see “Linking to Registered Data Sources”.)

You can do this in two ways: using the External Data dialog or using the Navigator. If your file has named ranges or named tables, and you know the name of the range or table you want to link to, using the External Data dialog method is quick and easy. However, if the file has several tables, and you want to pick only one of them, you may not be able to easily determine which is which. In that case, the Navigator method may be easier.