Downloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 hyperlinks, it's difficult to download each file one-by-one. Thanks in Advance, Br, AnupamPower Automate/Query Assistance - Add new table in file to bottom of existing/trend assistance
Forgive me if this has been answered elsewhere, I have had a look and not been able to find! Essentially, I have set up a flow using Power Automate that saves an XL I receive via a scheduled email into a sharepoint location. I have then created an excel document that queries this file in order for me to maintain a daily report. My issue is this. I am currently trending the data, but the only way I have of doing this is by copy and paste into a separate sheet (adding to the bottom of the previous data each day/week (select timescale) manually) as the data gets overwritten on each data refresh. I'm sure there is, but is there a way via either macro or power automate of me automating this process so that each day the table in the new file is just added to the bottom of the existing?? Thanks in advanceAutomating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!
Power Query: convert table type column to JSON string
Hi, I have generated a query in PQ with aggregates a column of mail adresses to the unique mails. Now the other columns are put together in one single column of type "table": When clicking on such a Table link I get How can i convert that into a JSON string? Ferom my knowledge it should look like: [ { "Path": "\\xyz", "Server": "xyz", "owner_count": "0" }, { "Path": "\\abc", "Server": "abc", "owner_count": "2" } ] (and so on...) Any idea how to achieve that? The parse option is greyed out... Thanks in advance
Display a different colors for field in chart
Hi, we have to display different colors for current temp in chart below based on user mode selected where iscurrent column is 1. For example, Below visual shows data where deviceid selected is B0965C2B9CF2A6C855A3C245F6B72F1A: The color of the current temp should vary according to the user mode where iscurrent is 1. Therefore in this case, usermode is auto So color should be grey. if it is heat then red & if its cool then blue. Below measure i created, but i am confused how to apply them for above visual when updatedon date column is in x-axis. Dax: Column Color = VAR _UserMode = SELECTEDVALUE('HeatSense_Device'[UserMode]) RETURN SWITCH( TRUE(), _UserMode = "cool", "#12239E", _UserMode = "heat", "#FF8C00", _UserMode = "fan", "green", "#808080" ) Please advise! PFA file hereHeatsense - Copy - Copy.pbix Thanks in advance! SergeiBaklan
Filter function
Dear Experts, Greetings! I have a data like below:- Each row has two rnti's (Col-C and Col-D), and their corresponding numofPrb are in Col-F and Col-G, I want to prepare something like Col-J and K, for the rnti's with their corresponding numOfPrbs in a single column. Thanks in Advance, Br, AnupamExcel Performance Issue with Linked Workbooks - Data Update Delay
Hi Microsoft Community, We are experiencing a performance issue with linked workbooks in MS Excel. Here’s our problem statement: We have two workbooks (Workbook1 and Workbook2) that contain one or more worksheets. Workbook1 (Sheet-1) is linked to Workbook2 (Sheet-1) using standard Excel formulas to connect specific cell data. However, when we update cell data in Workbook1 (Sheet-1), which is linked to Workbook2 (Sheet-1), it takes approximately 10 minutes for the data to reflect in Workbook2. The records we are working with are in the thousands, which may contribute to the delay. We are looking for any possible optimizations or solutions to reduce the time it takes for the data to update. Any guidance or suggestions on how to improve this performance issue would be greatly appreciated. Thank you in advance for your help! Best Regards, Vipin Kumar
Query for Power query , Power pivot and Power bi launching
I am not able to run power query, power pviot and also power bi. If i choose file in data from excel to import file for power query it opens but immediately the closes and open a recovery file. If i want to open the power bi file the app opens for just 10 second but again the app closes. further if i want to click power pivot then in manage i get the error of no data model is abled to load. I have office 365 and windows 11 is installed. all updates are already done. Kindly help
