User Tools

  • Vistasource Document Library

Cell Status Messages

When a record has no value, the cell displays #N/A. When an Excel spreadsheet file containing RTD formulas is opened, all values display as #N/A until the cells are updated.

In RTSHARE, when an Excel spreadsheet file containing RTS_SHARE and RTINSERT_SHARE formulas is opened, all values display as #N/A until the cells are updated.

Similarly, when editing, copying or cutting/pasting a real-time or RTSHARE formula, the cell displays #N/A until the value of the cell changes and the cell is updated. A cell which references a cell with a #N/A status message also displays #N/A.

If a cell displays #VALUE!, the formula is incorrect. For instance, if an invalid field name is entered, the cell displays #VALUE! and the status window displays information from the data distribution system. When using RTSHARE, the status window displays information about the error. A cell also displays #VALUE! if it references another cell which contains #VALUE! or #N/A or no data.

See Also: