Excel Date Picker
Hello , I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate different date format and make it unique across the document. I was able to get a date picker add-in however this wont work because I am sending to users please see below:
Creating Sankey Diagrams
Hi, Does anyone have any guides for creating Sankey Diagrams in Excel. I deal with the analysis of a reasonably long process which has various customer inputs and outcomes. I am looking for a visual way to show everyone who came into the process, and what happened to each person. Sankey Diagrams seem to fit that bill perfectly. Any help would be appreciated. Thanks T
Power Query error 'The key didn't match any rows in the table.' when combining
Hello everyone, I'm trying to merge multiple excel files into one spreadsheet using Power Query, but I receive the following error when doing so: An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Client Lists Kind=Sheet Table= Now a bit of information on my data sheets. The workbooks I'm trying to combine are tabled and also contain 2 tabs each. I'm trying to specifically combine 1 of the tabs from each sheet. In the Power Query navigator, it shows the options of 'Table' and the named tab I want to focus on. I tried to separate the 1 specific tab into one book and ensured all of my books have the exact same headers. When I try to combine I still receive the same error. Do I have to un-table my sheets? Or do I have to create a new book for the specific sheet I'm looking to combine? Please help!
Real time Microsoft Forms results in Excel Worksheet
Hi, I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has been filled in, the table used for the invoice is not updated. Does anyone know if it is possible to automatically add new Forms responses to an Excel table, or to obtain the data in another way? Thanks in advance, Suzanne KepelChange from absolute to relative path in Power query
I often have to change the actual path of my workbook, or share it, so I want to change the query location in a way that as long as both files are in the same directory, they work Source = Excel.Workbook(File.Contents("C:\Users\me\Documents\file.xlsx"), null, true), I want that as long as file.xlsx is in the same directory as my workbook, it will find it Source = Excel.Workbook(File.Contents("\file.xlsx"), null, true), Ive try this but does not work
