Removing RBA/RMI Branding and Personal Metadata from CMRT, EMRT, and AMRT Files

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

  1. Confirm that removal of the applicable RBA/RMI branding has been authorized.
  2. Preserve an untouched copy of the original or controlled master template.
  3. Create a separate copy specifically for external distribution.
  4. Complete all approved workbook modifications before removing metadata.
  5. 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:

Remove the following properties from this file

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.

  1. Open the distribution copy in Microsoft Excel.
  2. Select File.
  3. Select Info.
  4. Review the properties and related document information displayed on the page.
  5. If available, select Check for Issues, followed by Inspect Document.
  6. 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.

  1. Save the updated workbook.
  2. Close Microsoft Excel completely.
  3. Reopen Windows File Explorer.
  4. Right-click the distribution copy and select Properties.
  5. Open the Details tab.
  6. Confirm that the applicable Author, Last saved by, Company, and other identifying fields are blank or no longer display the information intended for removal.
  7. Open the workbook and confirm that the worksheets display correctly.
  8. 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

Complete before external distribution

☐ An untouched source or master copy has been preserved.

☐ The clearing process was completed on a separate distribution copy.

☐ Removal of the applicable RBA/RMI branding was authorized.

☐ Visible logos, names, and branding references were reviewed.

☐ Authors was reviewed and cleared where applicable.

☐ Last saved by was reviewed and cleared where applicable.

☐ Company was reviewed and cleared where applicable.

☐ Other personal and identifying properties were reviewed.

☐ Headers and footers were reviewed.

☐ Comments and notes were reviewed.

☐ Hyperlinks and email addresses were reviewed.

☐ Hidden worksheets, rows, and columns were reviewed where appropriate.

☐ The file was saved, closed, and reopened.

☐ The Details tab was checked a second time.

☐ The workbook opens successfully.

☐ Required formulas, validation, protections, and reporting functionality still work.

☐ The final file name is appropriate for external distribution.

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.