Forum Discussion

Copper Contributor

Jun 02, 2023

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

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: "You cannot perform...

Office Scripts

BradynHin

Copper Contributor

Jun 05, 2023

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

Copper Contributor

Jun 25, 2023

BradynHin 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.

DanDunne
Copper Contributor
Jun 26, 2023
DanDunne

I figured it out. For some reason workbook.getProtection().unprotect(); wasn't working (to unprotect the whole workbook for editing).

As a workaround I had to put in workbook.getWorksheet("<your sheet here>").getProtection().unprotect(); for each section I wanted to edit. Hopefully this gets addressed by Microsoft at some point in the future. This might also only be a problem for power automate to Officescripts as opposed to inherent to officescripts (which was why it was hard to track down the error).

This was also on an .xlsm file so things may still be okay on the .xlsx if doing a run script from power automate.

Anyway I hope I save people from the headache it caused me!