"You cannot perform the requested operation.", code: "AccessDenied", method: "addTable", line: 9}

Question

The following is my code in excel under the automate tab which when ran in a workbook with a sheet called "STU Chassis" regardless of the data contained gives this error {message:&nbsp;"You cannot perform the requested operation.",&nbsp;code:&nbsp;"AccessDenied",&nbsp;type:&nbsp;"Workbook",&nbsp;method:&nbsp;"addTable",&nbsp;line:&nbsp;9}&nbsp;How can I fix this?&nbsp;function&nbsp;main(workbook:&nbsp;ExcelScript.Workbook)&nbsp;{&nbsp;&nbsp;try&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;//Sets&nbsp;the&nbsp;Active&nbsp;Worksheet&nbsp;to&nbsp;the&nbsp;chassis&nbsp;worksheet&nbsp;in&nbsp;the&nbsp;workbook&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;stuChassis&nbsp;=&nbsp;workbook.getWorksheet("STU&nbsp;Chassis");&nbsp;&nbsp;&nbsp;&nbsp;//Get&nbsp;used&nbsp;range&nbsp;of&nbsp;previously&nbsp;mentioned&nbsp;worksheet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;stuChassisUsed&nbsp;=&nbsp;stuChassis.getUsedRange()&nbsp;&nbsp;&nbsp;&nbsp;console.log(stuChassisUsed)&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Add&nbsp;a&nbsp;new&nbsp;table&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;stuchassisNew&nbsp;=&nbsp;workbook.addTable(stuChassisUsed,&nbsp;true);&nbsp;&nbsp;&nbsp;&nbsp;stuchassisNew.setName("STUChassisTable")&nbsp;&nbsp;}&nbsp;catch&nbsp;(error)&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;console.log("There&nbsp;are&nbsp;already&nbsp;tables&nbsp;present&nbsp;in&nbsp;STU&nbsp;chassis");&nbsp;&nbsp;&nbsp;&nbsp;console.log(error);&nbsp;&nbsp;}return;}

sergeibaklan · Answer

BradynHin&nbsp;
Can't reproduce such error, even on protected sheet. If you run on new workbook with such named sheet, do you have an error?
&nbsp;
Just in case, slightly modified the script
function main(workbook: ExcelScript.Workbook) {

try {
  const stuChassis = workbook
    .getWorksheet("STU Chassis")

const stuChassisUsed = stuChassis
    .getUsedRange()

stuChassis
    .addTable(stuChassisUsed, true)
    .setName("STUChassisTable")

}

catch (error) {
    console.log("There are already tables present in STU chassis");
    console.log(error);
  }

return

}

bradynhin · Answer

SergeiBaklan&nbsp;Yes, even in a new workbook and using your revised code, I get the same error. Could it be a permissions error?

sergeibaklan · Answer

BradynHin&nbsp;
That's usually workbook/sheet protection, but in that case I have another error

If not protection have no idea what it could be.

bradynhin · Answer

UPDATE: This appears to be a permission or software issue. I ran the sample program "Create, Sort, and Format a Table" and get the same error even on untouched workbooks. I have even tried with different accounts and different machines on my network with the same result. The strange thing is this all worked last week before Friday when I started getting the error.

dandunne · Answer

BradynHin&nbsp;did you work out a way around it?My problem comes into play where half my script will work but it will have a "You cannot perform the requested operation." for a setValue operation on a single excel cell but only through power automate. Originally I thought it was something to do with something parsing through with my string variable but it doesn't seem to be that.

Forum Discussion

"You cannot perform the requested operation.", code: "AccessDenied", method: "addTable", line: 9}

6 Replies

Resources