More Problems with Excel 2010 xslm

Do a search on google eg linked below

https://www.google.com.hk/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=Repaired%20Records%3A%20Drawing%20from%20%2Fxl%2Fdrawings%2Fdrawing2.xml%20part%20(Drawing%20shape)

You will see millions of people suffering this problem where they have a slightly more complicated .xlsm file that when saved in Excel 2010, it gets corrupted and pictures/charts and button controls gets deleted.  Usually the file had started its history in Excel 03 then 07.

MS seems to have no proper fix. except tell users to recreate the file into a 2010 Workbook.  Well for some people that just requires too much time although one should consider this as a mini project to fix the problem.

However, here is a short term work around. 

Assuming you only have Excel 2010

Open the xlsm.  Make you changes like adding a formula to a cell.
Do a Save As for the file but save it in 2003-07 xls format.  It will prompt for issues.  Click OK.
Close Excel
Open the new .xls file in Excel 2010.
Do a Save As again and save it as a .xlsm file.  Close the file and Excel.
Open the new .xlsm again in Excel 2010.  

And voila it seemed to have saved without getting the file corrupted and then removing its charts/pictures and button controls.

There is a second method that can also side step the problem.  I think it shows up this is a bad bug from MS which they ought to try to address.

Open the xlsm.  Make you changes like adding a formula to a cell.
Do a Save As for the file.  Change the name of it.  Keep it as xlsm  Click OK.
Close Excel
Rename the file back to its old file name.  
Open the new .xlsm again in Excel 2010. 

And voila.

Apparently, this bug is NOT just affecting xslm file, it affects xlsx files that have formulae and links, references with other work books.  It affects files who had a history of being started in 2003 or before xls format.