Error: Delete method of Range class failed, System.Runtime.InteropServices.COMException

We are running Jet Reports on a terminal server and accessing data on a database server. All users seem to be able to run the saved monthly templates without a problem. However one user began getting the following error intermittently about 2 weeks ago. No one else seems to be having problems but this one single user:

He opens the template but the error occurs as soon as he either clicks on design or refresh.

_______________________________________________________________

An unexpected error has occurred:

Delete method of Range class failed

System.Runtime.InteropServices.COMException

at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)

at Microsoft.Office.Interop.Excel.Range.Delete(Object Shift)

at Jet.Excel.JetRange.k()

at Jet.Excel.JetWorksheet.b(String A_0, Int32 A_1, Int32 A_2)

at Jet.Excel.JetWorksheet.d(Boolean jetTablesOnly)

at Jet.Excel.JetWorkbook.s()

at g.f(Boolean saveUserData)

at Jet.JetDispatcher.e(Boolean saveUserData)

at Jet.JetDispatcher.at()

at Jet.JetDispatcher.b(Object[] A_0)

at Jet.JetDispatcher.Dispatch(Object[]& args)

Harry Lewis April 12, 2018 15:24

Hi Peggy -

This will need to be resolved by someone who *can* access the report.

While it would seem unusual for only one user to be experiencing the issue... Generally, this technique should work:

1. Open the report, select a range of columns from B all the way to the left and unhide Column A.

2. Select a range of rows from row 2 all the way up and unhide row 1
3. Select the whole sheet by clicking on the arrow next to A1

3. From the Excel Home ribbon select Clear > Clear Formats.

4. Repeat this process for each sheet in the workbook (except if the sheet is a Pivot Table then just clear the formats of Row 1 and Column A)
5. If the report has Excel filtering enabled then disable it by going to the Excel Home ribbon > Sort & Filter > Deselect the "Filter" option.
6. Repeat step 5 for each sheet in the report (except for sheets with Pivot Tables).
7. Switch the report into Design Mode and save the report (possible under a new name - as a test)

Have the user (who has been experiencing the issue) try with this new version.

Edited by Harry Lewis April 12, 2018 15:25

Error: Delete method of Range class failed, System.Runtime.InteropServices.COMException

1 comment