unable to enable macros for tendering

Alok Gupta 0 Reputation points
2026-11-18T02:01:29.32+00:00

for govt tenders i have been using macros for boq for last so many years this time it is not enabling editing in sheet

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

2 answers

Sort by: Most helpful
  1. Hendrix-V 21,045 Reputation points Microsoft External Staff Moderator
    2026-11-18T06:30:19.95+00:00

    Hi Alok Gupta,

    Since the usual macro and Trust Center steps have already been covered, the next step is to identify what is actually preventing editing rather than changing additional security settings.

    Could you please confirm:

    • What exact message appears when you open the BOQ file?
    • Do your older BOQ files still open and allow editing/macros on the same computer?
    • Does the problem occur only with this newly downloaded tender file?

    If older BOQ files still work normally, that would help narrow this down to the specific workbook or how that tender file was provided, rather than a general Excel macro setting.

    Please share the exact warning/error text, or a screenshot with any sensitive tender information removed, and we can narrow down the next step.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

  2. AI answer

    2026-11-18T02:02:18.32+00:00

    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.

    1. Close the workbook and Excel.
    2. In File Explorer, find the downloaded BOQ file.
    3. Right-click it and select Properties.
    4. On the General tab, look near the bottom for:
      • Security: This file came from another computer…
      • An Unblock checkbox.
    5. Select Unblock, then Apply → OK.
    6. Reopen the workbook in the Excel desktop application.
    7. 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:

    1. Create a folder such as C:\Trusted_BOQ.
    2. Move the workbook into that folder.
    3. In Excel, open File → Options → Trust Center.
    4. Select Trust Center Settings → Trusted Locations.
    5. Select Add new location → Browse, and choose C:\Trusted_BOQ.
    6. 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:

    1. In Macro Settings, select Enable Excel 4.0 macros when VBA macros are enabled.
    2. Open File Block Settings.
    3. For Excel 4 MacroSheets, ensure Open is selected.
    4. Select Open selected file types in Protected View and allow editing.
    5. 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

    1. Information about the Attachment Manager in Microsoft Windows
    2. Macros from the internet are blocked by default in Office
    3. Add, remove, or change a trusted location in Microsoft Office
    4. Enable or disable macros in Microsoft 365 files
    5. Working with Excel 4.0 macros | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.