Loading
Everything HP200LX: Knowledge, Products, Service

 Archives
9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Links
Most useful, up-to-date Web sites devoted to the HP 200LX

Downloads
Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

 
Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)


 

 

Privacy Policy

Lotus 1-2-3

Lotus 1-2-3

LINKING LOTUS WORKSHEETS

The 1-2-3 file linking feature lets you use the values from cells in saved (source) worksheets in the current (target) worksheet in memory. This means 1-2-3 copies the value or solution of the formula in the source worksheet to the target worksheet, not the formula itself. Here's how to link to spreadsheets:

  1. 1. Move the cursor to the desired cell in the target worksheet.
  2. 2. Type a plus (+), followed by the file name enclosed in double brackets, followed by the cell reference. For example:
+<<A:\SS\DVDGET>>B2

The file reference is the location and name of the file. You need to enter the complete path of the file if it is not in 1-2-3's default directory. The cell reference is either the address of the source cell or its range name.

You may not include a linking formula in another formula of the target worksheet. Instead, you must place the linking formula in another of the target worksheet's cells, and then reference that cell in the other target worksheet formula.

Lotus 1-2-3 links only one cell of the source worksheet per target worksheet reference. Even if you specify a range in the linking formula (i.e. <<file reference>>A1..B2), Lotus uses A1 as the source cell.

For more information on creating a link, and the restrictions involved, see pages 2-45 to 2-48 of HP 95LX User's Guide.

Ahmet G. Ozisik

Istanbul, TURKEY

iPhone Life magazine


Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

 
We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.
 

Copyright 2010 Thaddeus Computing Inc