Hi
I had this working last year but am unable to replicate this however hard I try!!
I have some data which is importing into Google Sheets. I am now wanting to import the whole sheet into Excel.
Last time whatever I did I just had to click on refresh and the data would automatically update. However hard I try I cannot get this to work.
I am using Excel 2016 so not sure if this makes any difference. I have checked security settings and all ok.
I have managed to pull the headings over but not the data.
Any help would be much appreciated.
I had this working last year but am unable to replicate this however hard I try!!
I have some data which is importing into Google Sheets. I am now wanting to import the whole sheet into Excel.
Last time whatever I did I just had to click on refresh and the data would automatically update. However hard I try I cannot get this to work.
I am using Excel 2016 so not sure if this makes any difference. I have checked security settings and all ok.
I have managed to pull the headings over but not the data.
Any help would be much appreciated.
