Archive for April, 2015

Excel Tip! Changing columns and format over multiple sheets

I work with Excel so often that I forget that things I do all the time and take for granted may not be widely known or used.  Today is yet another example.  While working on a client spreadsheet I did something that made my client exclaim and stop me mid-stream to show him what I […]

Fast Tip Friday: Ask for referrals

Yesterday I was once again reminded of something I read in a book by Dale Carnegie: “91% of customers say they give referrals yet only 11% of salespeople ask for them.” One of my clients said they were really happy with what we had done and that they were going to refer us to their business […]

Building a report in Excel and getting the error “Initialization failed”? Check your password.

I was building a report for a client in Excel using an OLEDB connection to the back end data base.  Pretty standard stuff, do it all the time.  From my favorite SQL Query editor tool all was well.  Snap the SQL Select statement into Excel and all I can get is “Initialization failed” and no […]