Browse by Tags

Cracking The Code
Published Mon, Oct 4 2010 11:34 | Bob Phillips
Excel’s ability to run pivot tables against an OLAP cube in Analysis Services is a truly wondrous beast. The ease of use; volumes of data; the filtering; all of these provide a rich environment for users to easily inspect their data and get real...
Filed under: , , , ,
Who Scratched My Table?
Published Sun, Jul 11 2010 11:45 | Bob Phillips
One of the better additions to Excel 2007 are, in my view, the functionality added to tables http://www.jkp-ads.com/articles/Excel2007tables.asp . I was recently working on a 2007 project and I was looking to add some highlighting using conditional formatting...
Deploy Me Simple
Published Sat, Mar 27 2010 13:50 | Bob Phillips
Excel 2003 Addins In Excel 2007 Excel 2007 and 2010 is so different in concept to Excel 2003 and before that there are many new challenges in providing solutions that can be deployed in either version. One challenge that I have been faced with is creating...
Filed under: , , , , , ,
The XML Is On The Kid
Published Thu, Mar 11 2010 23:08 | Bob Phillips
I recently wrote about a database tool that I have built to facilitate adding stored procedures to databases, SP Builder . XL-Dennis made a couple of comments, one of which was with regards to the medium used for the script file. He talked about XML files...
OpenOffice Is Looking Good
Published Mon, Nov 9 2009 12:45 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 I have blogged previously about what a rubbish job MS have done with Conditional Formatting in Excel 2007, but it seems it is worse than I feared. In this same file I now had CF setup as I wanted,...
Ribbons - Gain Without The Pain
Published Wed, Sep 9 2009 10:57 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 If you are in the habit of building or customising Excel 2007 Ribbons, there is an indispensable new tool that has just hit the market. Andy Pope has released his RibbonX Visual Designer, which can...
Filed under: , , , ,
Conditional Formatting In Excel 2007 - Chav or Mini?
Published Tue, Sep 8 2009 9:06 | Bob Phillips
Yesterday I had an incredibly frustrating time. I was updating my RibbonX Autogen routine to handle more types of controls. This is driven from a worksheet, some columns of which are generated, some of which depend upon user input. So being a helpful...
Autogen’ed Ribbon Code
Published Mon, Aug 24 2009 13:06 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 In a previous post, XML Is Such A Pain , I showed the technique that I use to simplify the creation of XML code for custom ribbons. This is a handy technique, as it means that creating the XML is very...
Filed under: , , , , ,
XML Is Such A Pain
Published Tue, Aug 18 2009 12:14 | Bob Phillips
Normal 0 false false false Creating a custom ribbon tab in Excel 2007 is a well known technique by now, and relatively easy to achieve. I will not go into the details here, there are many examples scattered across the web, I would suggest Ron de Bruin’s...
Filed under: , , , ,
Custom UDFs
Published Sun, Aug 9 2009 11:27 | Bob Phillips
Normal 0 false false false MicrosoftInternetExplorer4 In Excel 2007, if you start to enter a formula, such as =I, in the formula bar, it immediately provides you with intellisense of all functions starting with I. As with normal intellisense, the more...