Excel Macros Value changes automatically

The file when populated with actual data works well on my desktop and on other client PC/server accessed through VPN. However, when the client accesses the same file, the IRR is shown as zero.