Hyperlink to Folder

[Steviebobs]

Hi, I have Office 365 now, but I have a spreadsheet that was created with Excel 2003 that I have an issue with.

I was using the spreadsheet on Windows 10 when I decided to move to a Mac. I have loaded Win 365 onto the new Mac, the old Windows 10 machine is not available.

The spreadsheet I used on the Win 10 was a log of my various holidays/vacations as follows. The column headers are the individual holidays/vacations and the cells below each header are the locations I visited on that holiday/vacation. Each cell is named by that location but also has a hyperlink that links to the photo folder for that visit. It has been really useful and worked. I migrated the spreadsheet to the Mac and it doesn't work. At first I though the reason was obvious, that the route in the hyperlink related to the folder structure of the Win 10 machine and of course it is different on the Mac. But on checking the hyperlinks address 'routes' they appear to have been modified to suit the Mac folder structure (Don't ask me how!!). But the real problem appears to be that on Excel 365, the hyperlink 'route' needs to end with an individual file, not a folder. I have tried testing by creating a new hyperlink but it always wants me to end with a file, and does not allow me to end with just a folder.

Any ideas. Perhaps it allowed a folder end in Excel 2003 but not in Excel 365?

Thanks - Steve

 

[Fluff]

No idea about Macs, but on a PC with 365 you can hyperlink to a folder.

 

[Steviebobs]

No idea about Macs, but on a PC with 365 you can hyperlink to a folder.

Hi, yes you are right, I can do it on my Win 10 laptop but not on the Mac. Incidentally, despite searching for answers on here before posting, my thread appears to have raised a previous thread about this and it appears it is an issue with the version of Excel. Thanks for your reply Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.