You can convert cells with formulas to values. Before extraction, create a copy of your workbook and convert all formulas to values. This way you are working with final calculated results and not formulas that have dependencies.

Btw, as an alternative, I am working on a project where we are building AI Agents to automate data processing operations, such as data extraction, and it's compatible with Excel, SQL, CSV, PDF, TXT, Email. If you think that might be useful for you, you can contact us via our website: https://www.starnustech.com/