How to check out whether BEX query cells are ACTUALLY input ready

Morning ,

I have BEX input ready query presented by Analysis for Office.

Sometimes data provider is locked or particular data slice is locked or adso was switched to load mode or any other issue so that any cell of the query is non-input ready.

Is there a chance to check out whether at least one cell of the query is input ready with VBA or ABAP?

Thanks

Thanks