4,375 questions
Excel Add-In custom Function's dialog box is not working
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
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.
Microsoft 365 and Office Development Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 52%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Elizabeth Samuel MSFT 11 Reputation points Microsoft Employee2022-04-27T22:30:31.523+00:00 This seems like the same issue reported on GitHub. Is that the case?
-
Swaroopa Rani 1 Reputation point
2022-04-29T08:36:31.887+00:00
Sign in to comment
Sign in to answer