How to ignore Privacy Levels in Excel

When you download an Excel file from the internet you may encounter some warnings.

External Data Connections have been disabled.

Excel is very cautious with files that connect to external sites. The first warning you’ll see will be related to external links.

You have to enable External Data Connections. You are connecting to Etsy after all.

Privacy Levels

The second warning you might get is related to Privacy. The error might sound like “Query is accessing Data Sources that have privacy levels which cannot be used together”. When you use API’s you could potentially also post data to the internet so Excel is making sure you know what you are doing. Here’s an example of this error message.

To get rid of this, you’d have to check off the Ignore Privacy Warning setting.

Go to the Data Tab – go to Get Data – Query Options

Next, click on Privacy in the Current Workbook section. Select Ignore Privacy Levels and potentially improve performance.

If you are using a Mac, go to Data tab – Get Data – Launch Power Query Editor.

Click on Options – Project – Privacy – and check on that box as in the image below.

That’s it. Now you are all set.

Microsoft has blocked macros from running because the source of the file is untrusted

Sometimes, Excel completely blocks the macros in a file to prevent malicious code from running on your computer.

If you trust the file, you can go right click on the file, click on properties and click on “Unblock” to allow the macros to run.