The options for making external connections with Excel on MacOs are limited. In Windows there are many more options, including “web page”, which is necessary to be able to synchronize. According to what I have researched and what I need is an ODBS to achieve it, but I don’t know what it is.
Which version of the Excel you are using? if you are using the never version of the excel, you can find the power query already installed, if older you should be able to install it to MacOS as well.
this video may give some some ideas: https://www.linkedin.com/posts/islamburcu_as-a-person-using-this-method-frequently-activity-7000095119492149248-0ozm?utm_source=share&utm_medium=member_desktop
1 Like
