23. A computer program product as recited in claim 21 , wherein each valid reference name of the set of valid reference names includes one or more of a row name, column name, table name, sheet name, and document name.
21. A computer program product for automatically completing a remainder portion of a name as it is being entered, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer-executable instructions for: processing circuitry configured to execute instructions stored on a memory to receive at least a prescribed number of consecutive characters of a name being entered into a first cell, wherein: the first cell is disposed in a third document; a first document has a first document name and a second document has a second document name; the first document includes a first sheet having a first sheet name and the second document includes a second sheet having a second sheet name; the first sheet includes a first table having a first table name and the second sheet includes a second table having a second table name; the first table includes a first row or column having a first or column name and the second table includes a second row or column having a second row or column name; the first row or column name and the second row or column name are the same; and the starting characters of the name being entered into the first cell are part of a string of characters found in the first row or column name and the second row or column name; the processing circuitry to determine a set of one or more valid reference names that include the starting characters of the name being entered into the first cell, wherein: a first valid reference name of the set of valid reference names comprises the first row or column name; a second valid reference name of the set of valid reference names comprises the second row or column name; and the first valid reference name comprises the first table name, the first sheet name, and the first document name, or the second valid reference name comprises the second table name, the second sheet name, and the second document name; and the processing circuitry to provide the set of valid reference names as selectable auto-completion options to enable selection between the first valid reference name and the second valid reference name.