There is a way to open Excel safely which prevents macros from running. - Excel sheet calculations will still run.

Here's how to do it:

Step1: If downloading a file from the internet, click on a link to download the file - save it... if not, skip to step 2.

Step2: Hold down the CTRL key, then open Excel. You will see the following messagebox:

Click YES You'll know if you have done it right as Excel will have the words: "Safe Mode" at the top.

Now open the file and use it safely. Training Video on How to Open Excel Safely: