-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
power query from folder
-
Make Power Query (insert data from folder) files delete or ignore first row
Hi all, I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this: Unfortunately, the first row messes with the power query, so it returns this: If I remove the first row, my file works such...- Jyggalag
- Thread
- code conditional formatting easy excel fast formula help indexmatch jyggalag macro pivot table 365 power cable power query from folder svorkieboy vba vlookup
- Replies: 17
- Forum: Power Tools
-
T
Links failing to update when power query is refreshed
Hello Mr. Excel Friends, I have a few sheets linked to a master data sheet via power query. I had added some columns to the master sheet, but when I refresh the queries on the other sheets they do not update to include the new set (for example there was a table that initially had 23 columns...- Teleporpoise
- Thread
- excel link linked tables power queries power query power query from folder
- Replies: 2
- Forum: Excel Questions
-
R
Power Query from Folder
Hello, I set up a power query from folder. When I put in another folder I receive an error that says OLE DB or ODBC error: Expression Error. The key did not match any rows in the table.. An error occurred while processing table 'LDP5'. The current operation was cancelled because another...- Rcaaa
- Thread
- error folder operation power query power query from folder
- Replies: 5
- Forum: Power Tools
