Blog Archives

Excel 2013 Macro to set a filter

Recently I’ve been updated to Office 2013. Everything looks like is working smooth as always and even now Excel 2013 has a nice smooth effect when new data is displayed. While I was working on a new report I had

Tagged with: ,
Posted in Excel

Excel Macro to update filter

User: Can we make this month filter to have by default the year to date months selected? Me: … well… I guess I can have a look at it Inside of me: Back to VBA… after 12 years… So I

Tagged with:
Posted in Errors, Excel

Getting rid of Excel Services scrollbars

Excel Services scrollbards in SharePoint sites… you know, I know, we know… they know! How ugly and annoying they can be. Finally I discovered how to get rig of them, and it is quite easy: Before screenshot: On the right

Tagged with:
Posted in Excel, SharePoint

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other followers