saving xlsm file results in error & non-working Macros

Issue #741 closed
S.M.
created an issue

OS: OS X Python: 3.4.1 Office: 365 on Windows

Issue: Excels throws out a "repairing error" on renamed workbook, macros become unclickable.

I've read much about the problematic nature of xlsm files, and Excel's useless debugging tools after throwing the "worksheet was repaired". If anyone here can offer help nevertheless, it'd be super.

Below is the relevant piece of code:

wb2.active = 9 

#print(wb2.active)

#ws = wb2.get_active_sheet()  # get the active sheet

#ws['E2'] = 5

wb2.save(os.path.expanduser(path_to_temp))

As you can see, I even commented out the actual writing, and still just opening the file and saving to a new file results in an error that deems the workbook unusable. Unfortunately the workbook itself is a little sensitive so I can't just attach it, I'm wondering if maybe I'm missing a certain package/version/detail?

Comments (5)

  1. CharlieC

    You can try validating the file with the OOXML Productivity Tool as described in the documentation otherwise we can't do anything without a file.

  2. Log in to comment