baszoo.blogg.se - How to find data anomalies in caseware idea

HOW TO FIND DATA ANOMALIES IN CASEWARE IDEA MANUAL
HOW TO FIND DATA ANOMALIES IN CASEWARE IDEA SOFTWARE

Increase the size of the Linkage dialog so that the dialog is large enough to accommodate the length of the drop-down menus.įor more information, please see Selecting from Linkage Dialog Drop-down Menus in Word and Excel.Highlight the menu item that extends past the Linkage dialog and press Enter, or.If a drop-down menu extends beyond the bottom of the Linkage dialog, the value of the list items outside of the dialog boundary will not be accepted when the item is clicked. Note: This only occurs in Microsoft Office 2013. Selecting from a drop-down menu in the Linkage dialog is not working If you saved a backup copy prior to unlinking, a relink is not necessary simply revert to the backup copy. In protected workbooks, you cannot add new worksheets and thus Connector cannot store the necessary information to perform a relink. If the workbook structure was protected at the time of unlinking, then the unlink is permanent. This hidden sheet enables you to relink the document after unlinking. When unlinking, Connector creates a hidden worksheet to store unlinked information. Refer to the Help in Excel for further instructions. To unlock cells, you need to unprotect the worksheet first. Solution: Unlock cells to enable Connector to perform an unlink. The unlink function cannot modify locked cells and will skip these cells during the unlink. If the worksheet is protected, all cells in that sheet will be locked unless unlocked by the user. From the Formulas menu, select Calculation Options.If Excel crashes or becomes unresponsive during these operations, the calculation mode can remain set to manual.

HOW TO FIND DATA ANOMALIES IN CASEWARE IDEA MANUAL

In certain cases, Connector can switch the calculation mode to manual to perform other operations. Recalculate does not function when the Excel calculation mode is set to manual. Select the check box for CaseWare Connector and click OK.From the Manage drop-down, now select COMM Add-Ins and click Go.

Select CaseWare Connector and click Enable.

From the Manage drop-down, select Disabled Items and click Go.

Loading Connector UDFs when "#NAME" is displayed in cellsĮnsure to save your document after verifying the changes.Īfter an Excel crash, the Connector Add-in can become disabled.

Connector disappears from the Insert Function dialog.

Cannot convert file if another file with the same name is open.

Error: "Document needs to be recalculated".

Excel ribbon no longer responsive after batch DDE conversion.

HOW TO FIND DATA ANOMALIES IN CASEWARE IDEA SOFTWARE

Excel freezes when a document contains DDE links and Logitech software is installed.

Context (right-click) menu does not appear.

Excel does not open from the Document Manager.

Linking to CaseView database records returns #VALUE error.

Selecting from a drop-down menu in the Linkage dialog is not working.

The following outlines some of the common issues experienced when using Connector in Excel.