cache storage in Excel Custom Function

Asked Sep 13 '22 at 05:42

Active Sep 13 '22 at 08:44

Viewed 129 times

I want to store my searched values in key and pair in excel custom function. and when I search again with the same value it should return from the cache storage. How can I do that?

When I use office runtime storage it shows me error that is "wrong data type". Except officeruntime storage is there any other way to storage the value in cache storage?

edited Sep 13 '22 at 08:44

Eugene Astafiev

47,483
3
24
45

asked Sep 13 '22 at 05:42

Shiv Yadav

What code do you use for storing data? Could you be more specific? – Eugene Astafiev Sep 13 '22 at 09:53
I want to set the data which can be accessible in the custom function of excel and taskpane as well as. – Shiv Yadav Sep 13 '22 at 11:16
It seems you have already tried something, what is your code then? – Eugene Astafiev Sep 13 '22 at 11:21

cache storage in Excel Custom Function

0 Answers0