A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
For a BOQ workbook downloaded from a government tender portal, close Excel and remove the file’s Windows download block before reopening it and enabling editing.
Unblock the downloaded BOQ
Only do this after confirming that the workbook came from the official tender portal.
- Close the workbook and Excel.
- In File Explorer, find the downloaded BOQ file.
- Right-click it and select Properties.
- On the General tab, look near the bottom for:
- Security: This file came from another computer…
- An Unblock checkbox.
- Select Unblock, then Apply → OK.
- Reopen the workbook in the Excel desktop application.
- Select Enable Editing and then Enable Content, if those buttons appear.
Windows records internet origin information on downloaded files, which can cause Office to disable editing, macros, and other active content. Removing it through Unblock allows trusted macros to run unless another Excel or administrator policy blocks them.^1^^2^
If the BOQ arrived inside a ZIP file, extract it first and perform these steps on the extracted Excel workbook.
If there is no Unblock checkbox
Create a dedicated local folder used only for BOQ files whose source has been verified:
- Create a folder such as
C:\Trusted_BOQ. - Move the workbook into that folder.
- In Excel, open File → Options → Trust Center.
- Select Trust Center Settings → Trusted Locations.
- Select Add new location → Browse, and choose
C:\Trusted_BOQ. - Select OK until all dialogs close, then reopen the workbook.
Files in a trusted location bypass some Trust Center checks, so do not place unrelated downloads in this folder.^3^
If the file is on OneDrive or SharePoint, another supported option is to open it from the website with Open in Desktop App rather than downloading it through the browser.^2^
Check the macro setting
In Excel, select:
File → Options → Trust Center → Trust Center Settings → Macro Settings
Select Disable VBA macros with notification. This keeps macros disabled by default but displays a warning that lets you enable a trusted workbook individually. Avoid Enable VBA macros, because it permits all macros and can expose the computer to malicious code.^4^
If this BOQ uses old Excel 4.0 macros
Only if the workbook specifically uses Excel 4.0/XLM macro sheets:
- In Macro Settings, select Enable Excel 4.0 macros when VBA macros are enabled.
- Open File Block Settings.
- For Excel 4 MacroSheets, ensure Open is selected.
- Select Open selected file types in Protected View and allow editing.
- Select OK twice and reopen the workbook.
Microsoft still supports XLM macros in current Excel versions, but recommends migration to VBA.^5^
If editing remains disabled
- If Trust Center options are greyed out or revert after being changed, the computer is likely managed by an organization. An administrator can enforce macro and Protected View settings that users cannot override.^4^
- Ask the tender authority for a fresh copy if this specific BOQ remains blocked or appears damaged.
- Record the exact banner or error text—for example, “Microsoft has blocked macros because the source of this file is untrusted”, “Protected View”, or “file is locked for editing”—because these indicate different restrictions.
References