Excel Add-In custom Function's dialog box is not working

Swaroopa Rani 1 Reputation point

Our end goal is to share data from custom functions to the dialog box with custom functions runtime in windows excel desktop. The approach we were taking for this was OfficeRuntime.storage, which works in Excel live but not in Excel desktop. We're not sure whether OfficeRuntime.storage data is being passed to the dialogue box or not. Is it possible to pass OfficeRuntime.storage from custom functions to a dialogue box in Windows Excel Desktop?

The way we were setting the OfficeRuntime.storage is in the below image.


The way we were getting/reading the OfficeRuntime.storage is in the below image.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,715 questions
{count} votes