I would like to ask how can I get data from google sheet to excel in order to use them for pivot table as range.
I have data input sheet in google sheet. I would like to have them in excel and get all updates automatically as it is made.
Can I make a link from google sheet to excel to get the dates? For example, like I do with IMPORTRANGE formula in google sheet?