Daily Archives: March 1, 2012

Excel Crashes everytime you data sort, data filter in Office 2010

Symptom

Excel crashes when a particular spread sheet is being used, the spread sheet is a 2003 or 2007 version (or any spread sheet created before December 2010) the crash happens consistently when using a specific function such as Data Sort, Charting, Data Filters etc..

Often this suddenly happens to an old spreadsheet you have had a few years say from an older version of Office XP, 2003 and Office 2007.

Solution

1  Open the 2003 or 2007 file in 2010, then save it as a 2010 “Excel Workbook” (Select ‘Save As’, then under the filename select ‘Excel Workbook (*.xls)’).

This will save it in Excel 2010 format (However, this is not enough.  If you look at the top of the screen (in the middle  ) near the file name, you will see ‘[Compatibility Mode]’, indicating that you are not working on a pure Excel 2010 file yet, but a sort of hybrid version.

2  So, after saving the file, close it, then re-open it, and you will see that [Compatibility Mode] is now gone, and data sorts (and filters) now work!

This fix seems to work with any old .xls (2003 2007 Office Excel) files which occasionally crash.

Cause

I’m pretty sure there is a problem in Microsoft’s handling of the old Excel file format (.xls) and the newer XML file format (.xlsx).

For other issues which are more random run the Microsoft Office Repair in Control Panel (programs and features)

 

Health & fitness in the news – 01/03/2012

1. Why we need to convert sport to suit today’s lives
City AM

Maintaining and realising the sporting legacy of this summer’s Olympic and Paralympic Games is a huge challenge. But it also presents the chance for those governing sport to do things differently, and find a new generation of participants as a result.

City AM

2. Get fit with a virtual trainer
Evening Standard

It’s one thing taking up a new exercise regime, it’s quite another sticking to it. But help could be at hand: research from Michigan State University has revealed that having a virtual exercise partner can improve your motivation to get fit. A video game companion will last longer than you and will push you to work harder. On the same note, if you know you often stray off course, new apps can help you set up spoken comments which stream in from friends on sites like Facebook or Twitter and tell you to keep training.

Evening Standard

3. London 2012 Olympics: all 900 British Olympians and Paralympians to be tested for drugs in Games run-up
The Telegraph

All 900 British Olympic and Paralympic athletes will be drug-tested at least once in the build-up to the London 2012 Games, UK Anti-Doping has confirmed.

The Telegraph

4. Fancy lunch on the run? How exercising in your lunch hour can make you happier
Daily Mail

If you are too tired to go to the gym after work, there is an answer. More than two million of us now go for a run during our lunch hour – or a ‘runch’, as it has been dubbed – instead.

Daily Mail

5. The Rising Tide of Men Suffering Body Image Anxiety
Huffington Post

It appears that the contagion of body image insecurity that has historically afflicted women is beginning to infect men. Last year Central YMCA collaborated with the Centre for Appearance Research and the Succeed Foundation to undertake a major piece of research to better understand men’s attitudes to their appearance.

Huffington Post

6. Does Wii work? Study shows virtual boxing, bowling and dancing do not help children with exercise requirements
Daily Mail

They are billed as the perfect way to exercise and have fun, all without having to leave the comfort of your own living room. But playing active video games won’t help you stay fit, a study has found.

Daily Mail

7. Gastric bands at age of 14 in obesity crisis
Daily Express

Dr David Ashton, medical director at Healthier Weight, said: “The UK does not want to be champions of obesity in this Olympic year.”

Daily Express

8. Yes, you CAN think yourself thinner: The mind exercises that can help you stay slim
Daily Mail

‘There is a non-stop communication between your mind and body, but the mind is the most important because it drives your behaviour,’ says nutrition and exercise specialist Janet Thomson, author of Think More, Eat Less.

Daily Mail