TheOfficeCubicle

Modify, Change Microsoft Windows Default SMTP Virtual Server directory/folder

Have you ever needed to change the default SMTP Virtual Server directories or folders? PROBABLY NOT….Why? ….because you don’t work where I work. If you ever need to change the default SMTP folders such as …..Queue…Pickup….or Drop…then you need this!  It’s called IIS Metabase Explorer.  This program comes with IIS 6.0 Resource Kit Tools.  You…

Excel SUM ONLY Visible Cell, Row or Column – Stop Excel from calculating SUM of hidden cell, row or column

Had a user today call saying the Excel spreadsheet they created was calculating the SUM of invisible/hidden rows/columns. The problem was..they didn’t want Excel calculating the SUM of hidden rows and columns. A quick Google told me the SUBTOTAL function calculates the the sum of visible data and ignores invisible data. ALSO, from what I…