How to Use the INFO Function in Microsoft Excel to Retrieve System and Environment Information

When designing automated spreadsheets, financial models, or compliance workbooks that are shared across different departments, operating systems, and Excel versions, understanding the runtime environment is vital. A complex dynamic array formula or VBA macro might behave differently on Windows compared to macOS, or an automated reporting script may require confirmation of the current working directory. Rather than relying on custom scripts or manual auditing, Microsoft Excel provides the native INFO function. This built-in information utility inspects your active application state and returns operating system details, memory status, active calculation modes, and workbook directory paths.

Syntax and Argument Reference of the INFO Function

The syntax for the INFO function is concise and requires a single text argument:

=INFO(type_text)

The type_text argument specifies what environmental metric or system property you wish to inspect. Excel supports seven distinct argument types:

type_text Argument	Information Returned	Example Output
"directory"	Path of the current directory or folder.	C:\Users\Username\Documents\
"numfile"	Number of active worksheets across all open workbooks.	14
"origin"	Top and leftmost visible cell in the active window (Lotus 1-2-3 compatibility).	$A$1
"osversion"	Current operating system environment and version.	Windows (64-bit) NT 10.00
"recalc"	Active recalculation mode of Excel.	"Automatic" or "Manual"
"release"	Version number of Microsoft Excel.	16.0 (Excel 2016, 2019, 2021, and Microsoft 365)
"system"	Name of the operating environment.	"pcdos" (Windows) or "mac" (macOS)

Step 1: Check Current Directory and Folder Paths

To inspect the active directory path where Excel is saving and reading files:

=INFO("directory")

This formula returns the full directory string ending with a backslash on Windows or forward slash on macOS. If you are constructing dynamic file export names or auditing local paths before running workbook macros, referencing this cell ensures your paths match the current user session.

Step 2: Detect Operating System (Windows vs macOS) for Cross-Platform Compatibility

Because file path separators, keyboard shortcuts, and certain Excel features differ between macOS and Windows, you can dynamically adapt your spreadsheet logic using INFO("system") and INFO("osversion"):

Detecting Platform Type

=IF(INFO("system")="mac", "macOS Environment", "Windows PC Environment")

Displaying Full OS Build Information

="Running on: " & INFO("osversion")

When an auditor or remote team member submits a spreadsheet report, including this formula in a header or “About / Audit” sheet instantly documents the host OS configuration without requiring external diagnostic logs.

Step 3: Audit Workbook Calculation Mode (Automatic vs Manual)

One of the most frequent causes of user panic in financial spreadsheets is values not updating when inputs change. This happens when Excel’s calculation mode has inadvertently been switched to Manual (often caused by opening an external legacy model created in manual mode):

=INFO("recalc")

You can create a prominent, conditional formatting alert banner at the top of your dashboard:

=IF(INFO("recalc")="Manual", "⚠️ WARNING: Excel is in MANUAL calculation mode! Press F9 to calculate.", "✓ Calculation Mode: Automatic")

Pairing this formula with a bright yellow or red fill colour alerts users immediately if automatic formula calculation has been suspended.

Step 4: Count Active Worksheets Across Open Workbooks

When running large multi-workbook consolidating tasks, knowing how many active sheets are currently loaded into Excel’s memory helps assess resource usage:

=INFO("numfile")

This returns an integer representing the combined total of worksheets across all currently open workbook windows, enabling performance tracking during complex data processing.

Step 5: Inspect Excel Version Release Numbers

To ensure that advanced functions (such as dynamic arrays, LAMBDA, XLOOKUP, or LET) are supported by the host machine’s software version:

="Excel Version: " & INFO("release")

Values of 16.0 or higher indicate modern Microsoft 365 or Office 2016+ environments capable of evaluating dynamic array calculations.

Troubleshooting Common INFO Function Issues

• #VALUE! Error: Occurs when the type_text argument is misspelled or contains unsupported text (such as =INFO("memory"), which was deprecated in modern 64-bit Excel releases). Ensure your string strictly matches one of the seven supported parameters listed above.
• Values Do Not Update Immediately: The INFO function is a volatile-like environment function; it evaluates upon workbook recalculation. If you switch the calculation mode from Automatic to Manual, press F9 (or Shift+F9) to refresh the returned status.
• Security Sandboxing in Web / Cloud Excel: When using Excel for the Web in a browser or SharePoint environment, INFO("directory") may return restricted or simplified server strings due to browser cloud sandboxing. For local filesystem auditing, open the workbook in the desktop client.