Power Query freezes in Excel
Hello, I'm having issues editing queries in Excel. Whenever I enter a Power Query window, the window opens but shows no data and all excel sheets freezes. I can highlight the tools but they do not react when I try to click them. Nor can I close the Power Query window. The only way I manage to close excel is by forcing it through task manager in windows. I believe the problem started when I updated excel from verision 1902 to 1907. I have reinstalled office and I am now running version 1908, but the problem is still present. I have tried to access power query in multiple workbooks, but with no success. Has anyone experienced a similar problem? Any suggestions on how to fix this would be very welcome. Thank you for your time!
Run web queries
Hi, I am trying to import data from web but I have problems to use it. I am using an Excel version of Microsoft 365 on Mac. I have tried doing this without success: 1 st) Pate the url of the website from which I need the data on a word new document, leaving a few spaces. 2) I saved it as a .txt file and .txt file with the .ipy at the end of the name of the document. I saved it as MS or OS default (I've tried both). I saved it in the queries folder. (In there, are 2 .iqy documents that I didn't create it). 3) I opened a new excel file. I went to the data toolbar > Get external data > Run web query. It opened the Queries folder where appeared the file that I had created and these 2 files that I hadn't save it that I mentioned in 2. Here comes the problem: I can't select the files that I created. They are over there but they're impossible to select. Though I can select these 2 files and enter the data that are in it in my excel. But with my files, I just can't. Can someone help me with this?
Intelligent Search for Fact Repository - Help please!
Hello! First post here, I recently started a new job and am tasked with building a "fact repository" of key messages, stats, facts, and any other relevant information when requested by others within the company. Its purpose is so anyone can open it, search for a very specific piece of information and see what document it is from, when it was approved, and more information if they want to. Essentially a google but I only have about 50-75 pages worth of information extracted from dozens of documents that is relevant. Previously we have used a word document, but it is getting to be ~30 pages long, and I thought I could put this information into excel, sorting it in a way that would make it easier to find information. I am essentially looking for a "google function." I thought of adding key words under a heading attached to the paragraph describing what is actually in the paragraph which would enable a higher calibre of searching than simply searching for exact terms. It has to be smart because some people may put in synonyms or slightly different words which have the same meaning but would confuse the current search ability of excel. (Some older less technical people work here) I realise it is somewhat confusing, but it is not a typical excel type document. I am not sure if Excel is even the best software for this, but if someone thinks Word may be better, or another software, please let me know! I would really appreciate anyone's help, I want to learn and knock this out of the park! If you need any further details please comment.
Using SQL query with column as parameter?
Hi. This seems like a simple problem but I'm having trouble finding a solution for pulling data from a SQL database using an existing worksheet column as a parameter. I have a Column A and Column B. I want to populate Column B using an existing query with Column A as the parameter or "Where" statement. I have it working to execute on a single cell but can't figure out how to execute the query on all cells in the Column A.Help with this query, totally challenge
Like the picture a want to make a query to do it automatically this process 1. First I want to take the blue horizontal cells (PF7,PF8, S1, S4 and S6) and transpose it to vertical as I show you with orange color 2. Second, how can I do to transpose and the same time fille every row with the respective ID , status, puntuation , (2282) as I show you in green colorExcel doc very slow
Hey everyone, I'm having a problem with a few excel docs. I had a ton of connections in "query & connections" tab and it was making it so slow, so i decided to delete all of em via VBA using a code. It worked but my doc still very slow. What possible issue can it be? Thank you allDeleting a connection on Excel
Hello! I was trying to delete many connections at the same time at "Data<Queries & Connections" tab, but when i click to open the "Connection" tab, i just cant select as many as i want do delete. Before it was easily because in the "Data" tab there was only a "Connections" tab, so i could select various connections pressing "Ctrl" + "Shift" to delete as many as i would. I need to know if theres any way to bring back the "connections" tab instead the "Queries e Connection" tab, or if theres any method to delete many connection at the same time by this new tab. Thank you PS: Sorry about my English, its rusty. Hope you understand
