Microsoft xlsx for mac remove external link

broken image

You can disable the Security Warning by selecting “Disable all macros without notification”. The “Disable all macros with notification” option is selected by default. The Trust Center dialog box displays with the Macro Settings screen active. In the “Code” section, click “Macro Security”. To do that, you’ll need to enable the Developer tab, then click on it. We’ll also show you how to set up a trusted location for important files received from trusted sources.įirst, we’ll disable the Security Warning message bar. Office files placed in a trusted location are ignored when you open them from that location, and macros are not disabled. If you deal with some Office files that have macros from trusted sources, you can set up a trusted location in which you can place those trusted files for each Microsoft Office program. However, this doesn’t mean you can’t ever use macros in your Office documents again. We’ll show you how to disable the message without compromising the security of your Office programs.

broken image

If you know what you’re doing, and you don’t want to see that message every time you open an Office document, you can disable it. RELATED: Macros Explained: Why Microsoft Office Files Can Be Dangerous