I have a .xlsm file which includes some user defined functions.
One sheet uses these functions in formulae, e.g. cell content is:
=myFunc(“some arg”)
On my Mac version of Excel it works as intended. Now I also installed Excel in my iPad and when opening the file it shows for these cells only
#NAME?
There’s also an info showing that the mobile app doesn’t support macros.
Is there any way to cache the calculated values on the PC version of Excel so that the mobile app can at least show the last calculated value instead of #NAME?
