Hi Lea,

What kind of 'drive' are you referring to/what is the location of this drive; OneDrive (cloud), your local PC, a server etc.?

I'm not sure what you mean by 'connect'. How are you connecting the Excel file to a drive? Are you saving it there, are you getting it with Power Query, etc.? 

Why would a drive change? How would you know it has changed?

Ideally you will put those 30 files in a folder and you will get them from the folder with Power Query. Spreading 30 files over multiple locations will be a recipe for disaster.

Mynda

I will detail the case more -
It's a Google Drive cloud
I have 30 users updating the data every day on Google Drive
I need to have 30 Excel files in one folder - so I can consolidate them.
But every Excel file should get the data from Google Drive
So my question - how do I attach an excel file to Google Drive ??

Thank You!!

leah

Thanks for clarifying, Leah.

You can get the data direct from Google Drive with Power Query, as opposed to creating another Excel file for the purpose of getting it with Power Query.

Please see this post for instructions. Note: this is outside the scope of the course. Should you have any issues, I won't be able to help, sorry...not because I don't want to, but because I don't know as I don't use Google Drive.

Mynda