So i've been wasting a lot of time trying to solve this with no luck.
Someone in my team created a excel file by using "Export to excel". On her PC it works perfectly, however...nobody else can refresh the data from sharepoint online list.
I asked her for the connection file (LISTNAME.iqy), but i cant change the default one thats in the excel (if i go to Data, queries & connections -> connection properties -> definition and connection file). If i replace the connection file location (which shows on her C:/user etc) with the connection file location that she gave me (the same one from the settings) i get an error as in "Data will not be identical" and it removes the connection file location entirely.
Any idea how to fix this ? The excel export was done from a personal view, but afaik in the past sharing working without issues.
Any help would be appreciated, thanks.