Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Using the Navigator

  1. Open the Calc spreadsheet in which the external data is to be inserted (target document).
  2. Open the document from which the external data is to be taken (source document). Choose Web Page Query ( Calc) as the file type.
  3. Opening a file using the Web Page Query filter
  4. In the target document, open the Navigator.
  5. At the bottom of the Navigator, select the source document. (In the example below, the source is named actives.) The Navigator now shows the range names or the tables contained in the source document (the example contains range names; other documents have a list of tables). Click on the + next to Range names to display the list.
  6. In the Navigator, select the Insert as Link drag mode, as shown below.
  7. Selecting a data range in a source document, to be inserted as a link
  8. Select the required range or table and drag it from the Navigator into the target document, to the cell where you want the upper left-hand cell of the data range to be.
  9. In the target document, check the Navigator. Instead of a + by Range names, it shows a + by Linked areas. Click the + to see the same range name.
  10. Linked areas in target spreadsheet

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire