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. Read More→