Fix Missing Excel Document Properties in Windows File Explorer
Question details
Excel workbook properties appear in the workbook but are blank in Windows File Explorer on one computer. The user also wants to set these properties through VBA or VBScript.
- Product
- Microsoft Excel and Windows File Explorer
- Device & OS
- Windows 10 version 1903
- Scenario
- Viewing or entering a workbook's Title, Tags, and Comments metadata.
- Observed behavior
- The properties are present in the workbook and appear in File Explorer on another computer, but they are blank in Explorer on the affected computer.
Confirm that the workbook shows its properties in Excel under File > Info and that the affected computer can access the saved file. In File Explorer's Details view, right-click a column heading and select the Title, Tags, and Comments columns if they are not already visible.
Update Office and check the workbook properties again
Use this first when the same workbook displays its metadata correctly on another computer.
In Excel, select File > Account > Update Options > Update Now. If Update Options is unavailable, ask your organization's IT administrator how Office updates are managed.
Close and reopen File Explorer, navigate to the workbook, and check the Title, Tags, and Comments columns in Details view.
Search Microsoft Support for missing Office metadata in File Explorer and follow any guidance that applies to your Office and Windows versions.

Test the workbook in a new Windows user profile
Use a new profile to determine whether the missing properties are specific to the current Windows account.
Set workbook properties with VBA or VBScript
Use Excel automation to enter Title, Tags, and Comments in a workbook. This does not by itself fix an Explorer display problem.
Work with Excel workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open existing Excel workbooks to make migration straightforward; installing WPS Office does not repair missing metadata in Windows File Explorer.

Frequently Asked Questions
Why do the properties appear on another computer but not mine?
The comparison suggests the metadata is in the workbook and the display issue is local. Update Office through File > Account > Update Options > Update Now, then test the file in a new Windows user profile.
How do I show the Tags column in File Explorer?
Open the workbook's folder in File Explorer, switch to Details view, and right-click a column heading. Select Tags, or use More to find it in the column list.
Can VBA change the Tags property?
Yes. In Excel VBA, set ActiveWorkbook.BuiltinDocumentProperties("Keywords").Value to the desired tags, then save the workbook. Excel uses the name Keywords for the property shown as Tags in Explorer.
Does VBScript require Excel to set these properties?
The VBScript example on this page uses CreateObject("Excel.Application"), so Excel must be installed on the computer running it. The workbook must also be writable.
Will entering the properties again fix File Explorer?
Not necessarily. If the values already appear in Excel under File > Info and on another computer, the issue may be with the affected computer or user profile rather than missing workbook data.




