Show #BUSY! error in excel - (Low priority)

[Kedar Kulkarni]

Hi All,

I was trying a new feature by Microsoft https://techcommunity.microsoft.com/t5/excel-blog/advanced-formula-environment-is-becoming-excel-labs-a-microsoft/ba-p/3736518 and was trying LABS.GEERATIVEAI formula with no success however what caught my eye was the #BUSY! error in Excel. It could be a fancy name for the error Getting_Data in Excel however it does not return True if we used =IsError(cell) and returns #BUSY! which was a first.

My question is how to get #BUSY! in Excel as an error as the value is center aligned so it is treated as an error by excel and shows a better message when clicked on triangle or this is something only possible from javascript addins or we need newer excel PIA reference. This looks nicer than Getting_Data error, hence the question.

? 

thanks,

Kedar

[Govert van Drimmelen]

Hi Kedar,

 

As far as I can tell, this is only available from Javascript functions.

This seems to be tied into the way async functions are implemented for Javascript functions, which is not available for Excel SDK-based .xll add-ins.

 

-Govert

? 

 

thanks,

Kedar

 

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/9c810f08-35fa-41df-9f8e-2d3f8f6f5e55n%40googlegroups.com.