INFO

Microsoft Office Excel 2003

See Also

Security  Use this feature with caution. Sensitive or confidential information could be revealed to other users.

Returns information about the current operating environment.

Syntax

INFO(type_text)

Type_text    is text that specifies what type of information you want returned.

Type_textReturns
"directory"Path of the current directory or folder.
"memavail"Amount of memory available, in bytes.
"memused"Amount of memory being used for data.
"numfile"Number of active worksheets in the open workbooks.
"origin"Absolute A1-style reference, as text, prepended with "$A:" for Lotus 1-2-3 release 3.x compatibility. Returns the cell reference of the top and leftmost cell visible in the window, based on the current scrolling position.
"osversion"Current operating system version, as text.
"recalc"Current recalculation mode; returns "Automatic" or "Manual".
"release"Version of Microsoft Excel, as text.
"system"Name of the operating environment:
Macintosh = "mac"
Windows = "pcdos"
"totmem"Total memory available, including memory already in use, in bytes.

Example

The example may be easier to understand if you copy it to a blank worksheet.

ShowHow?

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Do not select the row or column headers.

    Selecting an example from Help

    Selecting an example from Help

  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
 
1
2
A B
Formula Description (Result)
=INFO("numfile") Number of active worksheets (varies)
=INFO("recalc") Recalculation mode for the workbook (Automatic or Manual)