relative reference


Also found in: Dictionary, Thesaurus.
Related to relative reference: absolute reference

relative reference

An address or pointer that changes when the target item is moved or the relationship to it has changed. For example, in a spreadsheet, a cell with a relative reference changes its formula when copied elsewhere. Contrast with absolute reference.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
where the prime ' denotes the operation with respect to the relative reference frame.
The missing component is "Criteria." We can type in a literal between quotes (but this is usually a bad practice) or we can refer to a cell address and not a named range so that it is treated as a relative reference. Ranges are absolute (non-adapting) references and are therefore stable, but they do not change as you copy them.
The way to make GetPivotData incredibly useful is to edit the default formula and make it a relative reference formula.

Full browser ?