It is possible that during the download your files have been damaged. 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. When they will not, then it states that Excel cannot open the file abc123.xlsx. Now the default save format option for Excel documents will be as a xls file. Click on Save on the left and in the Save files in this format drop down box, select Excel 97-2003 workbook. Now all the links I insert via the path name in that folder work. Open Excel 2016, click on File and select Options. 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. 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. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |