festple.blogg.se - Libreoffice power query

Do #5 but when loading to worksheet choose Add this data to the data model.

When I duplicate the query is does load to the worksheet but in doing so it inserts new columns so that the worksheet formulas are still pointing at blank cells whereas I need them pointing to the new data cells.Įdit: another attempt (after suggestion).

do #4 but after "convert to range" actually clear the cells so the worksheet formulas are pointing to blank cells.

do #3 but this time use "convert to range" to turn make the data to static before duplicating the query.

A table cannot overlap a range that contains a PivotTable report, query results, protected cells or another table". in the query pane right click "fruits" query and 'duplicate' and try and "close and load to." the new worksheet to try and override the query.

Copy the worksheet within the same workbook.

Before doing 1, in the query pane copy all the building-block queries from the original workbook to the new workbook.This problem could occur if the connection was copied from another workbook or the workbook was created in a newer version of Excel." This is not actually what I want (separate workbooks) my web search revealed many claims that I could copy to a new workbook and the query would be independent. This just results in a "The connection could not be refreshed. Currently both worksheets display the data from the original fruits query and any change in the original is reflected in both worksheets. I want to copy the "Template" worksheet within the same workbook such that the new worksheet contains a completely independent copy of the query so on the "Template" worksheet I can have "apples" data and on the new worksheet I can have "bananas" data. The "Template" worksheet has lots of worksheet formulas that refer to the data in the "fruits" query. "bananas" and the data will update accordingly. When I edit the "fruits" query, in the powerquery formula bar I can change a parameter with a value of "apples" to a different fruit e.g.

The custom query function itself refers to a query parameter to get a URL. The "fruits" query was created by invoking a custom query function. The "Template" worksheet has a powerquery query called "fruits".

I have an excel workbook with a worksheet called "Template".