I have a very unique problem importing few of the excel sheets from a sharepoint site. The formulas in the excel gives values in Sheet1 of the Workbook which I will use in PowerBI. Now these values appear as null. If I keep the Calculations to Manual they appear. If not, they don't. Please can someone help me to figure a way around this problem.