Forum Discussion
"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...
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.
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.