Home > Support > dsSummarizer FAQ
1. The report is incomplete – every second line is missing.
You are running the trial version of dsSummarizer. The trial version lets you try dsSummarizer but deliberately skips each second row when preparing the output workbook.
To obtain a complete report you will need to upgrade to UltraSleuth Gold.
2. Excel behaves strangely when I click on a hyperlink
Excel 97 users may experience strange behavior when clicking on a hyperlink. For example:
- you may be prompted to save the workbook containing the hyperlink
- the workbook containing the hyperlink may appear to close after the hyperlink is clicked
With regard to i, if you save the workbook when prompted, you should not be asked again.
With regard to ii, the workbook has not been closed. It has been hidden from view. To unhide the workbook:
- Open the Window menu from Excel’s main menu
- Click on Unhide
- When the "Unhide" dialog box opens, select the workbook from the list of hidden windows
- Click on OK
3. When I click on a hyperlink I am taken to a different worksheet
This happens when the target worksheet is hidden. You will need to unhide the worksheet. Follow these steps to unhide the worksheet.
- Select the workbook containing the worksheet that you want to unhide
- Next open the Format menu from Excel’s main menu
- Click on Sheet and then on Unhide…
- Select the sheet that you want to unhide from the Unhide sheet list in the Unhide dialog box
- Click on OK
4. dsSummarizer does not detect VBA code in the active workbook.
The active workbook contains VBA code but the "Procedures" worksheet does not list your VBA subroutines. There are two reasons for this problem:
- Your VBA code has been protected
- You are running Excel XP or later and your security settings disallow access to VBA code
With regard to i, unprotect your VBA code and re-run dsSummarizer.
With regard to ii, change your security settings so that dsSummarizer can access your VBA code. Follow these steps to change your security settings:
- Open the Tools menu from Excel’s main menu
- Click on Macro and then on Security …
- When the "Security" dialog box opens, click on the "Trusted Sources" tab
- Check the "Trust access to Visual Basic project" check box
- Click on OK
5. The double click feature does not work.
Nothing happens when you double click on the "Worksheet Formulas" worksheet. There are three reasons for this:
- You double clicked on a cell that doesn’t contain a cell address
- When you ran dsSummarizer your security settings prevented you from installing the double click feature
- Your security settings prevent macros from running
With regard to i, to activate the double click feature you must double click on a cell in column A that contains a cell address.
With regard to ii, change your security settings so that dsSummarizer can access your VBA code and re-run dsSummarizer. See "dsSummarizer does not detect VBA code in the active workbook" for step by step instructions on how to change your settings. With regard to iii, change your security settings to a lower level:
- Open the Tools menu from Excel’s main menu
- Click on Macro and then on Security …
- When the "Security" dialog box opens, click on the "Security Level" tab
- Select a lower security setting
- Click on OK
6. The double click feature jumps to the wrong location.
When you double click you jump to a cell on the current worksheet instead of the cell containing the worksheet formula.
This problem arises when you double click on a cell border. Ensure the cursor is clearly inside the cell before you double click.
7. The double click feature jumps to the wrong cell in the target worksheet.
Later versions of Excel allow the owner of the spreadsheet to prevent the selection of locked cells when a worksheet is protected. When a user is not allowed to select locked cells in a protected worksheet, the double click feature will jump to the first unlocked cell in that worksheet. To resolve this issue, the worksheet should be unprotected. Follow these steps to unprotect the worksheet:
- Select the worksheet that you want to unprotect
- Next open the Tools menu from Excel’s main menu
- Click on Protection and then on Unprotect Sheet…
- The Unprotect Sheet dialog box opens if a password is required. Type in your password.
- Click on OK
|
|
