Operation is not allowed

G

Geetha

I am a VSTO 2005 user. We are getting the following error, although not
consistently, while trying to add a new list object in Worksheet.ListObjects
collection:

listObject =
myWorksheet.Worksheet.ListObjects.Add(Excel.XlListObjectSourceType.xlSrcRange, position.TopLeftCell,
Type.Missing, Excel.XlYesNoGuess.xlYes, Type.Missing);

"The operation is not allowed. This operation is attempting to shift cells
in a list in your worksheet."


Please note that this list object previously existed in the ListObjects
collection, and was then deleted, and is now being re-added again. Since it
is not happening consistently, I am not able to understand what might be
causing this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft.Office.Tools.Excel.ListObject 0
VSTO C# add in Outlook.Appointment error 0
Table formatting in C# 0
Excel 2000 open using C# error - Unable to cast COM object of type 1
Operation is not allowed when the object is closed 1
Listobject selected and Deselected event 0
Setting Range value using a single dimension array 0
Range name applies to list, or simply range; collection-index/member-ofprecedence 0

Top