Did you know that MasterMine does NOT have to ask you for your SQL password every time you re-open an existing report and refresh? By default, Excel does not save your password automatically. This is a security measure (added with Excel XP and later versions) to prevent unauthorized access to your data on the SQL server. However, if this level of security is not important to you, you can take two actions that will save you and your colleagues lots of time and effort.

1. Save the SQL password in existing reports:
- Open and refresh and existing report, entering the SQL password when asked.
- Click the Information button on the MasterMine toolbar, then click on the “Security” tab.
- Check the box that says “Save SQL password with pivot table.”
- Click on the “Save” button to the right.
- You should get a dialog that says “Security settings saved.” Click “OK.”
- Save the workbook.

2. Save the SQL password automatically in all new reports:
- Run the MasterMine “Create New Report” dialog.
- Click “Preferences” menu at the top.
- Click “Defaults” tab.
- Check the preference for “Always save SQL password for new reports.”
- Click the “Save and Close” button on the bottom right.

Automatic SQL password saving must be set up for each user, at the workstation level. Pass it around!