Is it possible to create a universal hyperlink in excel for windows and mac without programming

0 votes
For Windows and Macs, is it possible to create a single hyperlink to a folder or files in an excel cell?

Tried starting from paths smb:\ and file:\\ on Windows, similar on Mac, e.g. \192.168.100.60
Mar 28, 2023 in Others by narikkadan
• 63,700 points
557 views

1 answer to this question.

0 votes

You may learn whether it runs on Windows or Mac OS with INFO. Depending on your system, =INFO("system") will return "pcdos" or "mac".

Put it to use using IF or SWITCH:

=HYPERLINK(IF(INFO("system")="pcdos","path_to_windows_file","path_to_mac_file"),"Link_name")

=HYPERLINK(SWITCH(INFO("system"),"pcdos","path_to_windows_file","mac","path_to_mac_file"),"Link_name")

Further you can wrap it with IFERROR as INFO is not available in web versions:

answered Mar 28, 2023 by Kithuzzz
• 38,010 points

Related Questions In Others

0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,700 points
443 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
• 63,700 points
321 views
0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

answered Jan 21, 2023 in Others by narikkadan
• 63,700 points
321 views
0 votes
0 answers

How is it possible for DynamoDB to support both Key-Value and Document database properties at the same time

As per DynamoDB's documentation, it supports both ...READ MORE

Apr 5, 2022 in Others by Kichu
• 19,050 points
633 views
0 votes
1 answer

Getting friendly device names in python

Regarding Linux, if all you need is ...READ MORE

answered Mar 26, 2019 in Python by SDeb
• 13,300 points
1,675 views
0 votes
1 answer
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,700 points
1,706 views
0 votes
3 answers
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP