153 reputation
8
bio website
location
age
visits member for 2 years, 2 months
seen Nov 20 at 5:42

Nov
17
comment Query parameters in an external connection to sql server
Finally got a chance to do this, sorry it took so long! This works!!! My only suggestion would be to expand on point 3 as in my case I didn't have the connection set up and I'm not sure for example between SQL Server or SQL Server native client 11.0 etc. Otherwise great answer!
Nov
17
accepted Query parameters in an external connection to sql server
Nov
6
awarded  Popular Question
Sep
19
awarded  Popular Question
Sep
12
comment Google Chrome is adding a slash to my searches
@Cory I reported it as an issue to Chrome asking them to make an exception if this is indeed a new feature. Perhaps you should too. Under the chrome menu -> Help -> Report Issue
Sep
11
comment Google Chrome is adding a slash to my searches
I have this same issue, does this come from a recent chrome update? I'm sure I did not used to experience this. It's extremely irritating
May
27
awarded  Student
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings Would you mind writing up the full procedure you used to get it working with a simple query as an answer please?
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings I couldn't find any other way besides using VBA. Although in the end we stuck with a button rather than a cell change trigger to make it more obvious that there is VBA behind it
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
just tried that. No good for me I'm afraid :(
Feb
14
revised Page appears centered at 120% zoom but on the left at 100%
edited title
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
A colleague has the identical screens to me, same resolution, but his is centered by default.
Feb
14
revised Page appears centered at 120% zoom but on the left at 100%
added 40 characters in body
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
But how do I make this the default behaviour? If I do this, then I can zoom with the mouse wheel (holding control) and it stays centered, but if I click on that zoomy bar in the bottom right then it reverts back to the left.
Feb
14
asked Page appears centered at 120% zoom but on the left at 100%
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
So click on cell A1, press F4, and then drag it down and across.
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
Is this a single array formula? Is it a formula that has been auto-filled (dragged down)? Or are these completely independent formulae?
Nov
19
comment Excel Multiplication
@MatthewS. you should use multiple columns as J_D says. For example keep your original values in ColA, your multipliers in ColB (so can easily be unique for each row) and then in ColC it's just =A1*B1. Then you can just find the average of ColC
Nov
19
answered How to open Excel 2010 as separate files
Nov
19
accepted Offset the tickmarks of a secondary axis