asked on

XLSM file will corrupt on inserting shape object

Hello All,

I am facing a issue working with xlsm. I was to simply insert a shape object to format the checkboxes into groups. Unfortunately, whenever I add the shape object and then close and save the xlsm file, the next time I open it I get this error:
The file has unreadable content..do you want to recover?
I hit yes and the prompt stays every time I open the file and asks me to recover....
This is Exactly identical to this issue mentioned here >>
http://chandoo.org/forums/topic/unreadable-content-in-excel-error

Will I be not at all be able to add the shape object?

Please assist

thank you
R

Rayne

ASKER

Another thing I found out: First I removed the object from the workbook, saved it as xls format and then inserted the object and saved the file. When i opened the xls - it would not cry out any error as compared to the previous time.
Now I converted that xls file back to xlsm macro enabled file - and it still throws same the prompt...as before
My workbook has a lot of macro running so I had save it as a xlsm..

Rayne

ASKER

Further if I have to live with this limitation - is there a way to auto-recover every time the xlsm opens?
something I came across below - but its not working
https://www.experts-exchange.com/questions/24449218/'Excel-found-unreadable-content-in-'-excel-file-'-Do-you-want-to-recover.html

Rayne

ASKER

is there a way to auto-recover every time the xlsm opens? with the user not have to do the clicks for that..the previous soultion link takes into accountthe file path - that will not work as this xlsm will be passed on to several people who would use it

ASKER CERTIFIED SOLUTION