why i am unable to use itr excel utility after enabling the trust center settings

Question

Answer 1

The ITR Excel utility is not working because Excel is still treating the file as untrusted and is blocking macros and external content, even though Trust Center settings were enabled. The red bar at the top shows: “Microsoft has blocked macros from running because the source of this file is untrusted.” In addition, the specific cell being edited is on a protected sheet, so it cannot be changed directly.

Use these steps to resolve it:

1. Unblock the downloaded file in Windows
   1. Close Excel.
   2. In File Explorer, right‑click the ITR Excel file and select Properties.
   3. At the bottom of the General tab, if there is a message like “Security: The file came from another computer and might be blocked to help protect this computer”, check Unblock, then select Apply.
   4. Reopen the file in Excel and check if the macro warning disappears.
2. Move the file to a trusted location (recommended)
   If the file is trustworthy and used regularly:
   1. Close the workbook.
   2. Move it in File Explorer to a folder that is configured as an Office trusted location.
   3. If needed, add such a folder via File > Options > Trust Center > Trust Center Settings > Trusted Locations (see “Add, remove, or change a trusted location” in the references).
      Files in trusted locations run without being blocked by the Trust Center.
3. Check external content and macro settings in Trust Center
   1. In Excel, go to File > Options > Trust Center > Trust Center Settings.
   2. Under Macro Settings, select an option that allows macros (for example, enable macros with notification) if the utility is trusted.
   3. Under External Content, ensure settings are not blocking the connections the ITR utility needs (for example, avoid “Always block the connection of untrusted Microsoft Query files” if it uses .iqy/.oqy/.dqy/.rqy files).
   4. Select OK to save.
4. Protected sheet message
   The pop‑up “The cell or chart you’re trying to change is on a protected sheet” is expected for many official utilities. Only the input cells are unlocked; other cells are intentionally protected and cannot be edited unless the sheet is unprotected with the correct password (usually not provided). Enter data only in the designated input cells.

If the workbook is opened from a network or email location and the above steps do not help, save it locally first, then repeat steps 1–3.

---

References:

• External data connection disabled
• Block or unblock external content in Office documents
• Change macro security settings in Excel