Last seen: Jul 3, 2025
Sheet1is not added by code, it is the initial sheet that is in the newly added workbook (when you create a new workbook, it does not come empty, there...
Where did you saved the test file? Location is important. OneDrive has some specific issues, so I suggest saving the file in a location where yo...
Your formula: = Table.AddColumn(#"Added Conditional Column8", "Merged", each Text.Combine({[#"PO < " & Text.From(HourBand3) & "hr before...
Hi Bax, The query from the file you attached is refreshing without any errors.
Hi Julia, From excel Data tab in ribbon, when you display the Queries in the side panel, right click that query and you'll see the Load To menu. No...
Sheet1 = Legacy Query Sheet2 = Formula: A1 = Sheet1!A1 Expanded this formula to A1:E50 because we haven't got so much entries in this live data. With ...
There is no way to get the current file full path in power query... You still have to use a defined name in a cell with this formula: =LEFT(CELL...
Glad to hear you solved it. To get data from a sheet in the current workbook, if you don't want to use a named range as suggested above, you have t...
Excel.CurrentWorkbook() only returns defined names (only those referring to a range) and table objects, not sheets. If you want to get the range "A...
Just noticed that it's not your topic... Please do not use other topics to post different problems, start a new topic instead. I think Current...
When I load into a new worksheet, it came up with the error "Expression Error: we couldn't find an Excel Table named '68Ga!_FilterDatabase'. ...
The source of my Query is defined as: Excel.CurrentWorkbook(){[Name="Query!example"]}[Content] Are you sure? The exclamation mark is an invali...
Hi Steve, Looks more like a finance problem, it's not my field of expertise to review financial calculation, I have no idea if the results are corr...
You have to copy first. You get the error because there was no copy action before pasting.
Hi Sherry, Put the following code in a normal vba module (included also in the file attached), should do what you need: Option Explicit S...