Right Click Is Not Working In Excel 2010

Sometimes right click won’t work in Excel 2010, but there is a fix for this. If right click isn’t working in Excel 2010: Close Excel 2010 Navigate to C:\Documents and Settings\%username%\Application Data\Microsoft\Excel or C:\Users\%username%\AppData\Roaming\Microsoft\Excel if you are using roaming profiles Delete (or rename) Excel14.xlb Start Excel and see if this fixes the problem If right […]
Continue reading…

 

How To Find Cells With Duplicate Values In Microsoft Excel

Did you know you can find cells that are duplicated between two columns in Excel? Here’s how to find cells with duplicate values in Microsoft Excel… The following code will find duplicates of the cell A1 in column B (ranged 1-250, extend the range if required) and list the contents: =IF(ISERROR(MATCH(A1,$B$1:$B$250,0)),””,A1) To use this, insert the […]
Continue reading…

 

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Excel Connection Manager

When making a call to the connection manager with SQL Server Integration Services to write to Excel, you get the following error: [Excel Destination [62]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304. There may be error messages posted before this with […]
Continue reading…

 

Macros May Contain Viruses. It Is Usually Safe To Disable Macros

When opening a Word or Excel file, you may get the following security warning: Security Warning Filename.doc | xls contains macros. Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality. To fix this, you must first understand what a macro is. A […]
Continue reading…