Forum Discussion
Formulas Blocked
Need help with Formulas being "blocked"
I have 2 x Workbooks, in 1 Workbook formulas are working in the next, I keep getting "#BLOCKED!", but no reason, I am using an array formula.
3 Replies
Block or unblock external content in Office documents
To help protect your security and privacy, Microsoft Office is configured by default to block external content—such as images, linked media, hyperlinks, and data connections—in workbooks and presentations. Blocking external content helps to prevent Web beacons and other intrusive methods that hackers use to invade your privacy and lure you into running malicious code without your knowledge or consent.
With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns.
Information on where the file is, such as OneDrive or SharePoint, is of advantage.
As well as, if possible or necessary (like in this case), a file (without sensitive data).
In this way, you will come up with a proposed solution much faster and more precisely.
This also makes it much easier for the helpers to provide the help that they would like to offer you.
It helps both :).
Here is a link with information on how you can quickly find a solution that is most suitable for you.
Welcome to your Excel discussion space!
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
In retrospect, most likely that this is what is being sought.
Thanks for your help 🙂🙂
