import formulas from openpyxl.reader.excel import load_workbook fpath = "Book1.xlsx" wb = load_workbook(filename=fpath) ws = wb.worksheets[0] xl_model = formulas.ExcelModel().loads(fpath).finish() xl_model.calculate() ws_dict = xl_model.write()['BOOK1.XLSX'] wb = list(ws_dict.values())[0] wb.save(fpath)