hey team,
i have an online google sheet that live updates from our CRM system.
I'm wanting to have my excel sheet 'link' to this google sheet so i can manipulate the data accordingly.
I've saved it as an online CSV & tried as a live updated 'website' however i can't seem to link to it in excel.
I'm using excel for mac 16.63.1
i've tried the 'get from html' under the get data section, however can only seem to look locally or within my sharepoint.
i can't manage to point anything to an 'online' location
any thoughts?
i have an online google sheet that live updates from our CRM system.
I'm wanting to have my excel sheet 'link' to this google sheet so i can manipulate the data accordingly.
I've saved it as an online CSV & tried as a live updated 'website' however i can't seem to link to it in excel.
I'm using excel for mac 16.63.1
i've tried the 'get from html' under the get data section, however can only seem to look locally or within my sharepoint.
i can't manage to point anything to an 'online' location
any thoughts?