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.

Cote d'Ivoire Puma away shirt WC 14

Now this would have been a fantastic shirt had it been just a bit smaller since it is actually very loose fit although you see pictures of the tight ACTV version modelled by the players.

It's quite standard crew collar.

Great badge as usual.

Nice details on the sleeves and shoulders.  The patterns are a great touch of character.  Great take on the elephants.

The cat jumps towards the elephant.

Clean back.  Overall nice material tool, this was a nice shirt.  It's just too loose for me even a small size feels really big.

Poland Nike shirt 14

This was another steal from elevens.com.hk.  It was not a bad effort from Nike but I feel they can do a lot better for Poland rather than just a template with a line down the middle.  Considering some of the classic adidas shirts that Poland had in the late 70s especially the one with the red pinstripes.  You ought to think they could do better.

Well Nike are boring anyway.  So boring that you can actually buy this team wear shirt and then perhaps stitch the crest on.

One decent thing was the crest.  They do place it well.  And it's a nice white eagle crest.

Material is pretty standard.  Just find the fit rubbish for Nike shirts.  They are way too big but it's easy to get it altered if required as the seams are straight forward.  Anyway, it's an OK shirt, just wished they could have spent more effort on a more classic look.

Boot Configuration Data (BCD) store is missing - Another Option

Many people had seen this dreaded error where Windows 8 suddenly comes up with a message after a shut down and fails to boot up

And then many of us are cursing oh, no I have no recovery USB stick readied for a such an event because I have been lazy.  With many of the potential solutions outline in this post http://pcsupport.about.com/od/fixtheproblem/ht/rebuild-bcd-store-windows.htm

And guess what pressing F11 on start did not work.  Going to the UEFI settings only gets you to the BIOS settings and there seem to be no setting there to allow you to get out of seeing this error screen.

Well, it turns out there is still another option.  I contacted my machine's manufacturer (Asus) who told me their machines requires one to press F9 on start up to get to an option screen.  However, on the BIOS settings, it is important to firstly turn off the Fast Boot option if it was on.

Once Fast boot is disabled, press F9 continuously on startup and voila the screen like below appears.

Choose the keyboard and then another option screen appears.

It turns out that in some cases like mine, just choosing the Continue option from the above screen, can correct the BCD corruption problem.  Although I must admin others may be suffering a bigger problem with the harddisk for Windows to report such an error.  And a full recovery may be required.  At least it gives the users a chance to select the Troubleshoot option and boot in Advance Mode.

Belgium Burrda away shirt 14

I got hold of the away shirt for Belgium, the last one made by Burrda.  Needless to say I personally preferred these than the adidas ones now.  I thought they had a nice character about them especially the collar and the cuffs.

The sash diagonal is pretty nice in a black background great use of national colours.

Decent badge.

These shirts had a good shape about them with excellent length sleeves.  Great fit.  

Here is where Burrda need improving.  Or may be I have worn this too much but after several washes, the transferred bran logos are loosing their colours.

The ones on the sleeves even suffering worse.

The print transfer at the back us coming off.  But then again I have had the same problem with some adidas shirts for example the Mexico away shirt where the letters at the back have come off.  So Burrda could do better though.

Overall I do like this shirt very much.  The material, design and for is great.  Just hoping they could have improved on the logo print.

France retro shirt

This was a remake of the legendary France Euro 84 shirt by adidas.  But since they do not currently hold the franchise, they can't put in the French FF crest.

Short sleeve and great fit.  Such a classic.  You just wished adidas would make them like this more often.

The material is cotton with elastane feel.  Not bad to wear and stretchy.  Bring back the memories.

Napoli Macron shirt

Been quite interested with Macron.  Although I think most people can't stand them or have said their shirts fall apart etc which I know it's untrue.  If anything they are actually better than the big three manufacturers.  This Napoli shirt was picked up out of interest since seemed to be so many of them around for sale.

The sponsors spoil the shirt.  It just does not sit well.

Otherwise design is good with the collar and colours.

Excellent sleeve length.

Material use by Macron is stretchy elastane.  This is quite a tight fit shirt but it's great to wear.  I think this was a player's edition since it appears to be even more tight fit than usual even for a medium size.