My Excel Jump List stopped adding Recent Files

Transparent Boundary LineMy Problem

Excel Jump List stopped adding Recent Files
Excel Jump List shown above the Task Bar.

I had a problem where I had MS 2010 Excel pinned to the Task Bar but the Excel Jump List stopped adding Recent Files. The Jump List is the one you see when you right click on an icon of an application pinned to the task-bar. Some programs (not all) show recently used files on this list. The user can then choose to permanently pin them to the Jump List. On the right is an example of an Excel Jump list.

In my case new recently used files stopped appearing on the MS Excel Jump List. I read through various bulletin board threads on the Internet but their suggestions did not resolve the problem.

Transparent Boundary Line

My Fix when the Excel Jump List stopped adding Recent Files.

This is how I resolved it. I repaired my MS Office application. The application has this facility built in. To repair it go to Control Panel > Programs and Features and right click on MS Office Professional Plus 2010 (in my case). The options are Uninstall or Change. Choose Change and the following window opens:

Excel's Jump List stopped adding Recent Files

Select Repair and click continue. This will start the repair process which will take several minutes. I think it more or less re-installs Office but doesn’t interfere with your settings. Beware that you may find other Office Jump Lists get cleared. But they all work afterwards.

Excel Templates for Body Weight Records

Excel Templates for Body Weight Records
Excel Graph of Helpful Colin’s Weight 2011. (Select it to enlarge it.)

“Happy New Year! In 2012 I resolve to lose weight (again).”

Well I resolved to lose weight every year since at least 2005 and some years I succeeded. One tool I require for this is an accurate record of my weight on a DAILY, yes DAILY, basis. I know all those slimming clubs advise against measuring weight daily but to me that is unscientific. High definition pictures are better than low definition ones and weighing every day gives a good weight definition. Anyone would think that the act of measuring weight caused it to change. (I know Quantum Physicists have their doubts.)

Being scientific requires not just the measurements written down somewhere but a graph to give a picture of what is happening over time. I want to see if my weight is actually heading down or up or staying put. During this time I have come down from my heaviest of 15st (95.25kgs) in 2005 and again in July 2007 to 13st 4lbs (84.36kgs) in the same year. Then I rose again to 14st 7lbs (92kgs) and came down to 13st 2lbs (83.46kgs) in February 2010. Now I have risen again to 14st (88.9kgs) a weight I swore I would never see again.

(Note to self: I need to be more scientific about regulating the calories I consume.)

For me as a Microsoft Excel user for many years, Excel was my tool of choice for recording and plotting the data. The rest of this post explains my method for collecting the data and the use of Excel to record it. Ultimately it offers Excel files that you can download to use as templates with your Excel software so you can record your measurements in like manner.

Having decided on the tool for recording the data I then had to decide when I would measure my weight. I chose first thing in the morning, before eating or drinking, after visiting the bathroom and without clothing (I keep my hat specs on). This way I get the feel-good-factor of seeing my lowest possible weight each day. (We lose up to 1.5kgs at night due to exhaling moisture in our breath and urinating.) The point here is not to come up with an exact daily weight – it’s impossible. Our weight fluctuates up and down 2 or 3 pounds throughout the day. The point is to try and arrive at a consistent set of measurements that can be used to display a meaningful average weight situation, over time, on a graph.

Continue reading “Excel Templates for Body Weight Records”