I have 2 work books that now (as of yesterday) fail on update.
here is the error message;
Updating workbook E:\Power_Update\Price Tables to SQL\test2.xlsm failed. Please check additional messages in task history for detailed errors. Opening file C:\Users\gord\AppData\Local\Temp\Power Update\46adc97c-17a8-4408-8ce4-6ca46ca74155\test2.xlsm failed. Please make sure that the user running the task has access to the file and that the file is not locked. Error: Exception from HRESULT: 0x800AC472 Trace: at PQRefresh.Program.ProcessExcelFileInternal(String taskName, String tempFolder, String ExcelFile, Boolean importToSQL, String TargetFolder, String baseURL, String folder, ICredentials cred, String credentialName, String file, String pbixPass)