Custom Add-in function between mobile-PC-Mac

Copper Contributor

Hi,

 

I'm using custom add-in functions and have a problem on excel files which are synced on Onedrive.

Normally there's no issue when I use the file on Windows Excel.

But whenever I open same file on Excel for macOS after I save it on Windows or iOS, all cells with add-in functions are changed into N/A because it contains path of xla on Windows or Onedrive.

To see calculated value, I should remove the path part by using Replace All.

 

Is there any way to avoid this problem?

0 Replies