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 the data, but not the database credentials.


$ xxd example.xls | less


The password and query can be removed from an external data set. Right click, choose External Data Properties.


The password can be removed from a pivot table. Right click, choose Pivot Table Options.


Posted in excel

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: