Showing results for 
Search instead for 
Did you mean: 

Broadcast Workbook with 2 settings run at same time

Active Contributor
0 Kudos

Hi All,

I have scheduled a workbook that has just 1 query embedded but have 2 settings for different filtered values.

However when I schedule them to run at the same time we get this error :-

System.Runtime.InteropServices.COMException (0x800 0A03EC): Microsoft Office Excel cannot access the file 'C:\WINDOWS\TEMP\BW\Analyzer\Workbooks'. There e are several possible reasons:u2022 The file name or path does not exist.u2022 The file is being used by ano other program.u2022 The workbook you are trying to save has the same name as a currently open workbook.

Having read this post and followed the instructions in the note mentioned we still get the error even though we have it set to run 1 workbook at a time.

Is there something else we need to do to stop this from happening.



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Craig,

Could you describe your solution, I'm facing same error.



0 Kudos

Hi Guys,

Have any of you found a solution for this as yet...??

Former Member
0 Kudos

Hi Craig,

Did you find a solution for this problem. I am facing a similar issue.

Please post if you did.