In report builder I am continually seeing this error message 4-5 times per day: 'Microsoft Excel is waiting for another application to complete an OLE action'. This always gives me an endless loop where I cannot escape the error message and return to editing the data block or Excel. The only way to continue is to close Excel is to 'End Task' or kill the Excel process which usually leads to file damage. The error almost always is generated after making changes to the 'filter' option of a dimension in the request wizard (page 2).
Occasionally, it occurs if the Excel window has been in the background for a short time.
I have tried a number of different setting changes in Excel such as 'Ignore DDE applications' in the advanced settings, but nothing works.
I am using Excel 2010, 32bit, Win7 with Report Builder version 5.2.10 but this bug goes back to at least v4.7. We have tried this in both normal and virtualised installations with the same results. Office 365 is also seeing the same issue (v.5.2.15)
Any ideas would be very much appreciated, Many Thanks Alan
I have been facing this issue for a while now. More often we face this issue if any of the parameters are violated while creating a data block. It should be our first approach to identify if any parameters are being violated by the RB data block.