Hyperlink to Folder

Steviebobs

New Member
Joined
Nov 3, 2020
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,618
Office Version
  1. 365
Platform
  1. Windows
No idea about Macs, but on a PC with 365 you can hyperlink to a folder.
 

Steviebobs

New Member
Joined
Nov 3, 2020
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,618
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,216
Messages
5,570,925
Members
412,351
Latest member
qwertyuiophilip
Top