3,282 reputation
815
bio website blog.meteorit.co.uk
location Leeds, United Kingdom
age
visits member for 4 years, 5 months
seen Apr 24 '13 at 23:20

Jan
23
awarded  Revival
Nov
4
awarded  Necromancer
Oct
29
awarded  Yearling
Apr
24
comment Display my user folder in the explorer tree in Windows 7
Good call, I've upvoted
Mar
18
awarded  Revival
Mar
11
answered External keyboard does not have Fn, I want to switch screens
Feb
27
awarded  Nice Answer
Feb
22
comment How to control Windows 7 snap feature with two monitors?
@Alvin - nice one. I like that the window that creates can be at an arbitrary position (depending if you drag a left corner or right) and width, yet Win + Down Arrow still restores it to last size and position.
Jan
12
awarded  Necromancer
Jan
12
answered Excel keeps reformating my numbers
Jan
12
answered Calculating a sum on an integer column when another column includes the year criteria for the calculation
Jan
12
comment Need to VLOOKUP in worksheet in the same workbook based on cell value
My guess is that the OP only wants to do this in the current workbook now, so is deleting "'[Datafile.xlsx]" from the CONCATENATE and therefore losing the initial single quote ' and ending up with a reference that the INDIRECT can't handle.
Jan
8
comment Navigate between text boxes in PowerPoint 2010
ESC is the key you need
Jan
8
answered Navigate between text boxes in PowerPoint 2010
Nov
5
comment Single click to accept meeting invite in Outlook 2010
You can hover on the items in the list of commands to see the underlying command such as AcceptInvitationSendResponse to be sure of getting the right one. You could also customise the main Ribbon in the same way and simply choose the "Accept" or "Decline" buttons so you can respond from your Inbox rather than having to open the message first.
Nov
5
comment Conversation clean up is greyed out
I use Exchange 2003 and Outlook 2010 and use "Clean up" to get rid of redundant messages in folders such as Inbox or Sent Items quite often. Difference is, I use "cached mode" rather than "online mode", which is specifically referred to in the error message you show here, so I think the mode is the problem, not the version. Ask your administrator if it would be possible to use cached mode so you can use this very useful feature to reduce your mailbox size (what admin won't like the idea of users with smaller mailboxes?!)
Nov
5
comment Excel 2007: Automatically insert row if previous row is filled in
Using a List (now called Tables) is definitely the best option. CharlieRB ought to make this an answer so you can mark it as accepted.
Nov
5
answered pivot table / chart default sorting
Nov
5
answered Assigning MS CRM task to someone else from Outlook?
Nov
5
comment Set a custom start date for week numbers
There's an an old KB support article for Office versions up to 2007 that explicitly says this can't be done. I'm not aware of any way to do it in 2010 either, so assume the article is still valid but just not updated to say it applies to 2010 too.