Good afternoon,

I'm working on a project at work currently and I've hit somewhat of a brick wall,

I have managed to set up a master sheet that takes the data from 3 separate workbooks and transfers it into a master sheet. This master sheet then collates all 3 tables into one large table.
To do this I have used the Power query function on Excel.

However I've stumbled across a problem that when a user other than myself attempts to use this file it gives me an error.

It would appear that it's trying to either reference a point on my local drive (This was all created/worked on via sharepoint) or it's trying to reference my credentials on sharepoint.

Does anyone know how to get around this?