How to automatically login and refresh a spreadsheet using a plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the following steps: 1) Open the Excel file. 2) Click on the iLEVEL menu option (it's on the top amongst other menu options such as 'Data', 'Review', Automate', etc..). This will present an iLEVEL login icon. Click on this icon and then enter my email address and password. In fact, once I've entered my work email, it uses SSO to gain access instead of entering a password. I do have a password should I need it (needs to be entered somewhere). 3) On the toolbar ribbon, under the iLEVEL menu option, there is the 'Refresh All' option. I click on this, wait a few minutes, and the spreadsheet has its data refreshed. iLEVEL is a third-party software solution. What I need to do is to achieve the above result automatically. At, say, 3am each morning, I would like automatically refresh the data. So there is the need to not only automatically login and refresh the data, but also to schedule the data refresh. The updated spreadsheet will then act as the data source for our reporting. In case it's asked, at this time, we cannot look to hook into the view/table that feeds this spreadsheet. Therefore, the spreadsheet is the endpoint. I will investigate this but if you are aware if this can be done or not, and point me in the right direction, it will be appreciated. I'm wondering if Power Query, or something similar, could achieve this. Thanks.How to automate a login and refresh of a spreadsheet via an Excel plug-in?
Hi. I have a requirement to automatically refresh a spreadsheet's data. I'm an Excel novice and have no idea how to do this automatically. To refresh the data in a manual fashion, I perform the following steps: 1) Open the Excel file. 2) Click on the iLEVEL menu option (it's on the top amongst other menu options such as 'Data', 'Review', Automate', etc..). This will present an iLEVEL login icon. Click on this icon and then enter my email address and password. In fact, once I've entered my work email, it uses SSO to gain access instead of entering a password. I do have a password should I need it (needs to be entered somewhere). 3) On the toolbar ribbon, under the iLEVEL menu option, there is the 'Refresh All' option. I click on this, wait a few minutes, and the spreadsheet has its data refreshed. iLEVEL is a third-party software solution. What I need to do is to achieve the above result automatically. At, say, 3am each morning, I would like automatically refresh the data. The updated spreadsheet will then act as the data source for our reporting. In case it's asked, at this time, we cannot look to hook into the view/table that feeds this spreadsheet. Therefore, the spreadsheet is the endpoint. I will investigate this but if you are aware if this can be done or not, and point me in the right direction, it will be appreciated. I'm wondering if Power Query, or something similar, could achieve this. Thanks.
How to transform wide-format data into the structure shown in 'Result' sheet using Power Query?
Hi everyone, I have a dataset in wide format in the "Data" sheet, and I’d like to reshape it using Power Query to match the format shown in the "Result" sheet. What the source looks like (Data sheet): Row 1 contains repeating column headers for measures like Sales, Purchase, Sell value, etc., grouped by date: | Product Brand | Product Name | Region | 01.05 Sales | 01.05 Purchase | ... | 01.06 Sales | 01.06 Purchase | ... | Note: The values in the file are randomly generated using a function, just for demonstration purposes. Rows where the Region column contains values like a1_1, a1_2, a1_3 are subregions, and the row with Region = a1 is the sum of those subregions for that product. What I want to achieve (Result sheet): I need each value in a separate row, with the following columns: Product Brand Product Name Region Date Measure Values Example: Product Brand Product Name Region Date Measure Values Brand A Product A_1 a1 2025-05-01 Sales 15 Brand A Product A_1 a1 2025-05-01 Purchase 22 Brand A Product A_1 a1 2025-05-01 Sell value 32 The Excel file contains two sheets: "Data" – raw data "Result" – expected outcome Can anyone help me write the proper Power Query steps (M code) to achieve this transformation? Thank you in advance! https://docs.google.com/spreadsheets/d/1nMz_TyXRSQNelq-cbUDfSf8ekKezGCTn/edit?usp=sharing&ouid=109036053433195029380&rtpof=true&sd=true
Help with Power Query and Power Pivot
First time trying to use these features. Have googled and read/watched numerous tutorials but as they dont really match my data set up I just cant follow how to get this right. Hopefully someone can help or steer me to somewhere that can. One thing I have learnt is that things need to be set up right in the first instance or it just wont work for you. I'm starting off with basic data comparing target sales figures with actual sales for a calendar year. The sales come in from 3 different streams (Dealers, Government and Direct) I basically only need 3 columns of data, the same for both target and actual sales. That being Stream, Month, Value. What is the best way to set this up (will eventually want to use Power BI to display various visuals)How to link data from one worksheet to another in a workbook?
Hi, I am wanting to find a way to how to format my file such that my excel sheets are interlink in a workbook. Sheet "Semester base dates - Column B = Column A", if on sheet "Tuition pattern" - Column I reflects sheet "Semester base date - Column B" eg sheet "Tuition Pattern - cell I15 = 11" it should link to sheet "Semester base date" - cell A41 "Because it is Semester 2 (cell B1); week 11 (I15)" on tuition pattern sheet - this should be automatically reflected on sheet "tuition pattern" column J (Cell J15) (42) Because sheet "semester based dates Cell A46" = 42 What I want to do is when I fill my data for column I - I want to find the corresponding week for automatic filling of column J - can I do that? *won't allow me to copy and paste my excel table to show example
How to chart this?
Need help on how to calculate then chart this. I have a number of pairs, which I’m imagining as a flow, but with some loops back, and branches: From To A G G C C D C A G F B E E F F E F D I’d like it to figure out a table/chart (but with arrows) like the attached image. It may have optional paths. Doesn't have to be like a flow chart, if there's another way for excel to analyze it. I don't *think* this is a complex b-tree sort of problem... TY in advance.
Count U slots
Dear Experts, I have a case like below:- So, there's a Worksheet "Calc" below where we have Slots from 0~19 two times from Col (C~V) and (X~AQ); In ,Sheet2 we have the Logic on how to count the U slots:- 1D --> 1 symbol DL 2DD --> 2 symbols DL 2DU/2UD --> 1 symbol for UL, 1 symbol for DL 1U --> 1 symbol UL 2UU --> 2 symbols UL 1S (for split) --> Half symbol for UL, Half symbol for DL Can you please provide a formula for Column AS and AT to count the U slots, using above Logic, Attached is the Worksheet.
Power Query is Missing Some Values on Import, Causing IDs to Map to the Wrong Records
Hi. I have a Power Query / Excel issue that I just cannot find a solution to, or a similar problem online. I have a third party cloud based database which I am querying into Excel via an OData connection. The source database contains some duplicate names. As this is real company data, I've created a little demo (screenshot below) to explain the problem. So say I had two companies called Bob's Buns in my original data set. Power Query does not pull the second instance of the name "Bob's Buns", which causes all the names below to line up with the wrong IDs. So now "12" is linked to "Clare's Cakes". You'd think I could just make sure that no two companies in my database have exactly the same name and this would fix the issue, but it doesn't. When I pull the data again after fixing the duplicates, it STILL results in this misalignment error. In fact if I renamed Bob's Buns (ID 11) to "Bob's Buns Bristol", and Bob's Buns (12) to "Bob's Buns Birmingham", Power Query still returns exactly the same result you can see under "What Power Query Returns" below. It's definitely the duplication causing the error, as there were a few instances of this within the database, and the same thing happened. I have done a static export to Excel from the source database, and the results line up correctly with their IDs. However, when I used OData & Power Query, I get this infuriating error. I hope I have explained myself OK! Help very much appreciated!Table Merge from Web
Dear Experts, I need to export the below in a Single Table from below link :- https://portal.3gpp.org/desktopmodules/Specifications/SpecificationDetails.aspx?specificationId=3283 But when I use PQ, it gives me into different Tables, and I have to combine them Manually as below:- How shall , I merge them all into a Single Output? Thanks in Advance, Br, Anupam
