queries

I have a report (.xlsx) with some data connections to a SQL query that sometimes crashes on certain people's PCs. They seem to get better reliability from .xls files, however some of the queries are quite expensive and take a while to run, and I'd prefer to disable the background refresh and...

Hi, I have a workbook that contains many refreshable web queries which I refresh using a command button. But how can I "pause" the VBA until queries have finished? As they take up to 2 minutes to complete and I want to manipulate the data afterwards Appreciate any help

Hi, I have hundreds of queries that reference a UDF name that I need to change to something else. I'd prefer not to manually go in to all of the queries. Is there a way to loops through my database and change all occurrences of the UDF name CC_PAYOUT_DATE and change it to #11/30/2018?

Hi, I have a series of queries in Access that use a UDF I created. I'm trying to link these queries into an excel sheet via ODBC, but the data won't pass through because it doesn't recognize the UDF from Access. I just want to be able to refresh the queries from Excel to feed my report...

I have the following queries set up: 1) FY131415 (357,000 rows) 2) FY151617 (6,146,235 rows) 3) AllFY (6,503,415 rows) This is just a combination of query 1 and 2 It takes a total of about 25 minutes to load this power query workbook and the data is updated daily so I need to update...

Hey! I have introduced several Excel files in the company, which use Power Query to consolidate different Excel files and prepare them accordingly. The structure is as follows: 1st file: - Query from Access - Querys from 3 Excel files 2.-5. File: Various Excel files. Some of these...

I'm hoping there is a much easier way of doing what I am doing. Firstly, this dummy document should illustrate things. We have our raw data (i've made the data by using another larger sheet and have about 7 queries in excel just to make it look like the first tab in the linked sheet). I then...

I have designed up a sheet that has a search based PQ. When you first open the sheet it automatically runs a "Refresh All Sheets" for the Power Queries. This shows a full list of all .CSV files in a specified folder (C:\CSV\). The user can then select one of these .csv files to "import". When...

Hi, have anybody experienced where their Excel version's Get & Transform is unresponsive? I have created a file and done some queries etc just to have it crash and now it does not even recognise that I had a query. Thank you.

I have a dashboard works now with tables, ranges etc. However, I want to improve it by linking excel tables to access queries (as opposed to copying and pasting). However, when I do this the array formulas I use in the dashboard stop working. Do array formulas not work with tables made from...

Hi! I just wanted to ask whether it is possible to mimic googles IMPORTXML Function in Excel 2016. I know about the "From Web" queries on the Data tab. Could they be used in a way where they return multiple queries in the same spreadsheet? What I mean is lets say that in column A I have 200...

Hi all this is just a general question re what drives files size in a Power Pivot model. I need to share my files with other users so they need to be as small as possible as most users only have a basic computer set up. i have created a file with only a very small amount of data in the data...

Dear all, I am trying to merge 2 queries. They both have unique numbers but whenever I link the two queries, duplicate rows appear. Not after the step "Merged Queries", but after the step "Exapended [name query]" ... I am desperately looking for the cause or a solution to my problem. In 1...

Good morning. I am looking for some VBA that would label each row in a table in sequence from 1 to 10. I am counting the number of times a model number comes up during the year. I have them in order of largest to smallest by top 10. I now need to label each row from 1 thru 10. Autonumber will...

Example: I have 3 columns. Col 1 is dates. Col 2 is numbers. Col 3 contains a 'A' or 'B' in each cell. So normally I select Col 1 and Col 2 for a chart and all good. But how do I select cells from Col 2 ONLY when an adjacent cell in Col 3 contains a 'B'? Thanks PS I do not mean manual...

Hi All, Below is my code. After every submit of my record, my user form goes initialize. This makes doubled the items in cmbActivity & cmbTaskStatus.. Any thing on this, which will not double the items in list.. Private Sub UserForm_Initialize() mTimer.TimerOn 10 BtnStart.Enabled = False...

Any advice appreciated. I've finally gotten passable at VBA/Excel but this issue is weird and when I search I just find articles on how to enable when I want to disable. I have a report that I edit for a company that is not on my network. I recently started having an issue because after making...

Hi, I have a spreadsheet, file size just over 2MB, file contains about a dozen queries. Not a huge amount of data, some table joins but not overly complex. What I've started to find is that when refreshing the queries, the memory usage (looking at Windows Resource Monitor) jumps rapidly from...

hello all, I'm New to Mr.Excel (Access too) I get this message - The expression you entered has a function name that Microsoft Access can't find." I copied the VB from a Mr.Excel video about "Auto BackUp" - I'm using 2007-2010 *I need help to resolve this error [code] Sub BackUp() Dim dTime...

Hi I have an excel file with various power query that are loaded to the data model as connection only. I've tried to save the file with a different name as a backup but now the queries don't work - they say no connection exists Is this a bug or do I need to reconnect the queries somehow - if...