Jan 04 2022 11:27 PM
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?