For Xlwings I've read up how to refresh an entire workbook(RefreshAll in excel file with xlwings) but what if I want to exclude some formulas? I have some formulas with values that I need to use but they can't be refreshed since they'll make a DIV/0 issue. The values will be part of other formula calculations though.
What I'm looking to do is:
- Update data in certain cells
- Refresh formulas excluding a subset
- Take data from formulas results that build on the excluded subset's values