In column C are cells with formula =HYPERLINK(CONCATENATE(A1,B1,".pptx"),"File") - (this link opens up the appropriate Powerpoint file) and this formula is copied down many rows. On my windows machine, as I change the values in B1 to different names, the hyperlink works fine (obviously as long as the file exists). However, when I put this on a MAC, at first the link does not work. However, if I go to another cell and I insert a link manually by selecting the file, that link works, and then my dynamic link works to that same file. It's like once I link to it manually, the other link will link to the file but not before.
Does anyone know why?