Monthly Archives: February 2009

Database passwords in Excel workbooks

Excel PivotTables are really useful for analyzing data. Excel allows me to use any database via ODBC to get data. Unfortunately Excel also stores the username, password and query in the spreadsheet which is bad, since I want to share

Posted in excel