![]() This has worked for me on a few different spreadsheets with files in different drives and it is the best solution I could find so far, through trial and error. Now all the links I insert via the path name in that folder work. Then the security window pops up, click yes and the folder opens. navigate back to your parent folder and click Grant Access. Click the link, and a Grant File Access window pops up, click Select. (I've found you can go far back on this if you need to, if files are stored in folders all over the place.) Then click OK and it will insert the hyperlink to that folder in the cell. You can transfer the files to your Mac and they should open up in the program assigned to that file type. If you used a cross-platform program (such as Microsoft Office) it will likely save files in a format that can be read by both your PC and your Mac. Click the triangle next to Open With, and choose Adobe Acrobat Reader or Adobe Acrobat from the pop-up list (if your preference is not on the list, choose Other to select it). Then I delete the file name (and any subfolders, if necessary) in the path until the path is only to the parent folder that contains my files. Yes, in most cases you should be able to open a file created on a PC on your Mac. Click the PDF files icon in the Finder to select it. Click select to navigate to the file I want to link to since it won't let me just select a folder. I just go to an empty cell, control-click and select HYPERLINK. I've found that I have to grant permission to the parent folder (in a roundabout way) that the files I'm trying to link to are in in order for my hyperlinks to work.
0 Comments
Leave a Reply. |