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.

login

$ xxd example.xls | less

password_in_spreadsheet

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

data_range_options

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

pivot_table_options

Advertisements
Posted in excel

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: