openpyxl writes formulas as strings with no cached values . Until you recalculate, every formula cell reads back as None to anything reading cached values — pandas, load workbook(data only=True), and most previewers. Use it to make implementation decisions and avoid common dead ends.