Python not reading cell in excel file

[wendysling]

Hi,

I am using Jupyter notebook. I created a script to open a few excel files and paste a summary dataframe in a new excel file.

All was working fine, but somehow today the coding is not capturing some of the cells that have formulas.

Before, it used to capture the value in the formula. Meaning, if the cell was =2+2, the new dataframe would have the value 4 in that cell.

Now it is only showing NaN.

Does anyone know why this is happening?

Thank you,
Wendy

[Larz60+]

Does anyone know why this is happening?

Hard to say unless you post some code.