Removing RBA/RMI Branding and Personal Metadata from CMRT, EMRT, and AMRT Files
Table of Contents
Use this guidance to prepare an approved distribution copy of a Minerals Reporting Template without unintended RBA/RMI branding, personal information, or identifying file metadata.
Quick summary
Removing logos or text from an Excel workbook does not automatically remove information stored in the file properties. Before distributing an approved CMRT, EMRT, or AMRT file, review both the workbook's visible content and its hidden document metadata.
Overview
Microsoft Excel files can retain document properties and personal information even after visible branding has been removed from the workbook. This information may continue to identify an individual, organization, or file owner when someone reviews the file's properties.
Potentially retained information may include:
- Author name
- Last saved by
- Company or organization name
- Manager information
- Document title, subject, category, or tags
- Comments, notes, or revision-related information
- RBA or RMI references stored within document properties
Important: This procedure removes applicable file properties and personal metadata. It does not automatically remove logos, text, hyperlinks, headers, footers, comments, hidden worksheets, or other branding contained within the workbook.
Templates covered
This guidance applies to approved distribution copies of the following Minerals Reporting Templates:
CMRT
Conflict Minerals Reporting Template
EMRT
Extended Minerals Reporting Template
AMRT
Additional Minerals Reporting Template
Before you begin
- Confirm that removal of the applicable RBA/RMI branding has been authorized.
- Preserve an untouched copy of the original or controlled master template.
- Create a separate copy specifically for external distribution.
- Complete all approved workbook modifications before removing metadata.
- Perform the metadata-clearing process on the final distribution copy, not on the master file.
Do not overwrite the controlled source file. Always retain an original copy so the approved template structure, formulas, protections, and reporting functionality can be recovered if necessary.
Remove file properties and personal information
The following procedure uses the file properties available through Windows File Explorer.
Step 1: Locate the distribution copy
In Windows File Explorer, locate the approved CMRT, EMRT, or AMRT distribution copy.
Step 2: Open the file properties
Right-click the Excel file and select Properties.
Step 3: Review the Details tab
Select the Details tab and review the information displayed in the file properties.
Pay particular attention to the following fields:
- Authors
- Last saved by
- Company
- Manager
- Title
- Subject
- Tags
- Comments
Step 4: Open the removal tool
At the bottom of the Details tab, select Remove Properties and Personal Information.
Step 5: Select the removal option
In the Remove Properties window, select:

Step 6: Select the applicable properties
Select the checkboxes beside the properties that contain personal information or RBA/RMI references.
At minimum, review and clear the following properties when they contain identifying information:
- Authors
- Last saved by
- Company
Step 7: Apply the changes
Select OK to remove the selected properties. Select OK again to close the file Properties window.
Inspect the workbook in Excel
For additional assurance, review the workbook from within Microsoft Excel. Depending on the Excel version and organizational settings, additional inspection options may be available.
- Open the distribution copy in Microsoft Excel.
- Select File.
- Select Info.
- Review the properties and related document information displayed on the page.
- If available, select Check for Issues, followed by Inspect Document.
- Review the inspection results before removing any additional information.
Use caution: Document inspection may identify hidden worksheets, comments, custom XML data, embedded objects, or other workbook components. Removing these items may affect template functionality. Do not remove technical components unless the impact has been reviewed and the change has been authorized.
Review visible branding and workbook content
File-property removal only addresses metadata. Review the entire workbook separately for visible or embedded RBA/RMI branding.
Review the following areas:
- Logos and images
- References to the Responsible Business Alliance or Responsible Minerals Initiative
- Worksheet titles and instructional text
- Cover sheets and introduction pages
- Headers and footers
- Comments, notes, and threaded comments
- Hyperlinks and email addresses
- Hidden worksheets, rows, or columns
- Shapes, text boxes, and embedded objects
- Named ranges or custom workbook properties
- Copyright, ownership, or licensing statements
Preserve template functionality: Do not modify required questions, formulas, validation rules, macros, worksheet protections, reporting logic, or the approved structure of the CMRT, EMRT, or AMRT unless specifically authorized.
Verify the distribution copy
Verification is required because some properties may remain visible until the file has been saved, closed, and reopened.
- Save the updated workbook.
- Close Microsoft Excel completely.
- Reopen Windows File Explorer.
- Right-click the distribution copy and select Properties.
- Open the Details tab.
- Confirm that the applicable Author, Last saved by, Company, and other identifying fields are blank or no longer display the information intended for removal.
- Open the workbook and confirm that the worksheets display correctly.
- Test the applicable template functionality before distribution.
Expected result
The final distribution copy should no longer display the selected personal information or unintended RBA/RMI references in its file properties. The workbook should also remain accessible and function as intended.
Final quality-control checklist
Troubleshooting
The personal information still appears
Save and close the workbook, then check the file properties again. If the information remains, open the workbook in Excel and review File > Info for additional properties or inspection options.
A property cannot be removed
Confirm that the file is not read-only, password-protected, open in another application, or stored in a location where editing is restricted. Create an approved local distribution copy if permitted and repeat the process.
The workbook no longer functions correctly
Stop distribution and compare the file with the preserved original. Restore the distribution copy from the original and repeat only the approved metadata-removal steps. Do not remove technical workbook components unless their purpose and impact are understood.
It is unclear whether branding can be removed
Do not distribute the modified file until the appropriate template owner or business owner confirms that the proposed branding changes are authorized.
Roles and responsibilities
| Role | Responsibility |
|---|---|
| File preparer | Creates the distribution copy, removes approved metadata, reviews visible content, and completes the quality-control checklist. |
| Template or business owner | Confirms whether branding may be removed and whether the resulting file is approved for its intended use. |
| Reviewer | Performs a final check of the workbook, file properties, naming, and template functionality before release. |
Need assistance?
If the file continues to display personal or RBA/RMI information, or if removing an identified component could affect the template's functionality, stop the release process and contact the appropriate template owner or internal support team for review.