Excel Power Query

Topic

New Reply

MICROSOFT 365 By Peter Deegan Power Query is the clever multifunction tool in Excel I could not do without. It not only adds essential features to Exc
[See the full post at: Excel Power Query]

4 users thanked author for this post.

Clay Gibney, fisher75, kewlputergeek, Norio

Reply | Quote

Replies

I had no idea.  I shall have to return my computer science degrees — I do not deserve them. 

Thanks, Peter!

1 user thanked author for this post.

Peter Deegan

Reply | Quote

I only recently discovered the amazing power of Excel Power Query! I use it to combine multiple worksheets into one large dataset that I reference with a pivot table. I’m using it in a checkbook spreadsheet where I record my bank transactions for multiple bank accounts.

Unfortunately, if you store an Excel spreadsheet on OneDrive (personal version), you’ll get this error if you have a power query that queries that spreadsheet.

“datasource.error: The process cannot access the file (xxx) because it is being used by another process”

I read that there’s a workaround if you use SharePoint or the business version of OneDrive, but no fix for home users on OneDrive.

Reply | Quote