I have two apps that were working yesterday but not day and was wondering if anybody else is having an issue of if anybody knows what more I can do to troubleshoot this issue. Here is the problem for one of the apps:
I have xlsx files in blob storage which I then collected and create a sharepoint file based on a a schedule, I then run a script on the file which only has one sheet.
Here is the script:
function main(workbook: ExcelScript.Workbook) {
let worksheet = workbook.getWorksheet("Worksheet");
// Add a new table at range B1:AV2 on worksheet
let newTable = workbook.addTable(worksheet.getRange("B1:AV2"), true);
// Add a new table at range B4:M6 on worksheet
let newTable_1 = workbook.addTable(worksheet.getRange("B4:M15"), true);
(I previously did not name the worksheet in the script but used active which work but read that you should reference the sheet)
The error that I'm getting is a 404 - with this message
{
"message": "We were unable to run the script. Please try again.\nWorkbook not found.\r\nclientRequestId: 1c60b1cc-a05a-4c66-a28d-0992fb6f01e4",
"logs": []
}
I have tried to get workbooks on the file but get the same error. The file is not corrupt and can be opened in excel and as stated before this step was working yesterday with no changes to it.


