It’s probably best not to use this option as it could potentially harm both your Excel installation and, potentially, your entire computer.ĭo you have a spreadsheet with a VLOOKUP formula in it, but you’re seeing a bunch of #N/A? Find out how to adjust your formula and display a 0 instead if it’s affecting other formulas. First, we need to enable Developer tab if you havent enabled yet. In the example, create a list of fruits, nuts, and vegetables in a. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).
Right click anywhere on the ribbon, and then click Customize the Ribbon. Disable all macros with notification (this is probably your current setting if you’ve never changed it) – Blocks macros, but gives you the option to run them by showing a notification with an Enable Content button. To turn on the Developer tab, execute the following steps.
The Macro setting options in Excel for Office 365 are:
