How to Fix the #BLOCKED Error from GET.CELL in Excel
Question details
The user needs to resolve a #BLOCKED! error that occurs when using the GET.CELL macro function in their workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Reopening or modifying a workbook that relies on the legacy GET.CELL macro function for cell evaluations.
- Observed behavior
- Excel returns a #BLOCKED! error in cells utilizing GET.CELL because security settings restrict access to legacy Excel 4.0 Macro resources.
Ensure the workbook comes from a trusted and verified source, as legacy Excel 4.0 Macros can occasionally carry security risks. Save any current progress before modifying your security configurations.
Adjust File Block Settings in the Trust Center
Modify Excel's Trust Center settings to allow access to the legacy resources required by the GET.CELL function for your specific workbook.
The #BLOCKED! error typically occurs because GET.CELL is an Excel 4.0 Macro (XLM) feature. Modern versions of Excel restrict these legacy functions by default within the Trust Center to protect users from malicious scripts.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner of the ribbon, and select 'Options' located at the bottom of the left-hand menu.
In the Excel Options dialog window, click on 'Trust Center' from the left pane, and then click the 'Trust Center Settings...' button on the right.
Click 'File Block Settings' in the left menu. Locate the settings pertaining to legacy workbooks (such as Excel 4.0 Macros or older workbook types). Clear the check boxes under 'Open' and 'Save' for the specific file types you need to allow.
Click 'OK' to save your changes. Close and reopen your workbook, then press F9 on your keyboard to force the formulas to recalculate and clear the #BLOCKED! error.
Move the Workbook to a Trusted Location
Bypass file block restrictions safely without lowering your global security settings by placing the workbook in an approved Trusted Location.
Experience Fewer Legacy Macro Errors with WPS Office
If you are tired of dealing with complex security blocks and legacy macro errors in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that handles daily data tasks effortlessly without the burden of restrictive legacy configuration menus.
- 1. Download WPS Office: Navigate to the official WPS Office website and download the free installer for your operating system.
- 2. Install the Application: Run the downloaded setup file and follow the standard installation prompts to install WPS on your device.
- 3. Open Your Workbooks: Launch WPS Spreadsheets to seamlessly open, edit, and manage your existing Excel files.
Frequently Asked Questions
What exactly is the GET.CELL function in Excel?
GET.CELL is an older Excel 4.0 Macro (XLM) function used to extract information about a cell's formatting, location, or contents. Because it is a legacy function, it cannot be typed directly into a worksheet cell and must be utilized through the Name Manager.
Why does Excel show a #BLOCKED! error instead of #VALUE!?
The #BLOCKED! error specifically indicates that Excel's security policies (configured within the Trust Center) are actively preventing the application from accessing certain resources, such as legacy macros, external links, or sensitive data types, to protect your system.
Can I use GET.CELL without saving as a macro-enabled workbook?
No. Because GET.CELL relies on Excel 4.0 Macro technology, any workbook utilizing this function must be saved as a Macro-Enabled Workbook (.xlsm or .xlsb). Saving it as a standard .xlsx file will strip the macro functionality and cause errors.
