Openpyxl: Excel formula & condition formatting removed

[JaneTan]

I need to read and write to an xlsm excel file. I used the below

1 2 3 4

import openpyxl file='....xlsm' wb=openpyxl.load_workbook(file, data_only=True, read_only=False, keep_vba=True) But I get the warning "conditional formatting is not supported and will be removed"

In my xlsm file:

Some of my conditioning format get removed, but not all
My formula are also converted to values.
I noted that the conditional formatting and formula that are removed have links to another sheet in my xlsm file.

How do I solve this?
I can't use "data_only=False" as I need Python to read the values of some formula.
Thank you