587 reputation
411
bio website
location United Kingdom
age
visits member for 3 years, 4 months
seen Apr 10 at 13:48

Feb
10
awarded  Citizen Patrol
Feb
10
comment Change data source from SQL to local worksheet in Excel
You can't switch between local and external data sources. You need to create a new PivotTable
Jan
21
awarded  Nice Answer
Jan
9
comment Convincingly “breaking” a system for a non technical user
Disable the firewall, and let the minions run amok!
Jan
9
answered Enter date in Excel
Dec
12
awarded  Notable Question
May
23
answered How do I separate three different phone numbers concatenated in one cell into three new rows?
Jan
24
comment Issue in Excel: Copy a cell with formula - pastes value of the copied cell
Have you tried running Excel in Safe mode?
Dec
9
awarded  Yearling
Oct
29
awarded  Popular Question
Jul
24
comment Searching for content in a large number of Excel files
@Bobert Yes, I misunderstood your question
Jul
24
comment Searching for content in a large number of Excel files
Windows Search indexes the content of Office files. It comes with Windows 7, but you can install it for XP.
Jul
22
awarded  Constituent
Jul
10
awarded  Caucus
Feb
23
comment What zip encryption is used by Windows Explorer
@Ramhound Yes, I'm trying to build the case for 7ZIP, which involves showing why the built-in functionality is insufficient.
Feb
23
asked What zip encryption is used by Windows Explorer
Dec
9
awarded  Yearling
Oct
22
comment Download only for optional updates in Windows 7
I have "download updates but let me choose whether to install them". I can tick the optional ones, but they don't download, and there is only the install button to click.
Oct
18
comment cd (change directory) to my home directory on Windows
If you are on a different drive to your user profile it wont change it for you, so you need to add the switch /D to cd to do this.
Oct
15
comment Download only for optional updates in Windows 7
Thanks, but the settings option seems to only apply to important updates. I specifically want to download when online, but install offline.