Linking Calc 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 >

This is Chapter 10 of the Apache OpenOffice 4.1 Calc Guide.

A PDF of this chapter is available from this wiki page.