title: pandas read excel values not formulas
body: <p>Is there a way to have pandas read in only the values from excel and not the formulas? It reads the formulas in as NaN unless I go in and manually save the excel file before running the code. I am just working with the basic read excel function of pandas,</p>
  
  <pre><code>import pandas as pd
  
  df = pd.read_excel(filename, sheetname="Sheet1")
  </code></pre>
  
  <p>This will read the values if I have gone in and saved the file prior to running the code. But after running the code to update a new sheet, if I don't go in and save the file after doing that and try to run this again, it will read the formulas as NaN instead of just the values. Is there a work around that anyone knows of that will just read values from excel with pandas?</p>