When you use load_workbook this doesn't retain the settings saved previously for worksheet.freeze_panes
code to recreate:
from openpyxl import Workbook from openpyxl import load_workbook wb = Workbook() ws = wb.active ws.freeze_panes = ws['B2'] wb.save(r'test.xlsx') new = Workbook() wb2 = load_workbook(r'test.xlsx') wb2.save(r'test.xlsx')
wb2 will overwrite the file's freeze_panes on the first sheet, when actually, it should retain it.
Running on 2.7 with v2.15 (i believe, have done pip install openpyxl --upgrade at 03/Mar/15)