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:
We Found Extra Characters at End of JSON Line
Using the JSON files provided on the Yelp website, https://www.yelp.com/dataset. When attempting to connect to the files via Excel's "Get Data" or Power BI, and error message appears stating "We found extra characters at end of JSON line." Attached is a sample of the data. Any ideas why the error message is being returned? Thank you in advance!
IF statement based on multiple columns.
Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing difficulty in getting the proper solution. It would be great if someone would help me to build a proper formula for this one. Problem statement: I have 3 columns for Vendors i.e Vendor 1, Vendor 2, Vendor 3. I want to put up a formula in "Vendor Master" such that IF "Vendor 1" is blank then it should return value from "Vendor 2" in "Master Vendor". IF "Vendor 2" is also blank then it should return value from "Vendor 3". IF "Vendor 3" is blank then it should return a string "No Vendor". It would also be great if someone could tell me how this can be done in Power BI as well. Quick response is highly appreciated. Thanks in advance.
Auto refresh excel sheet without opening excel files
I am trying to refresh the contents on the excel web version automatically without opening the excel file I am using the TODAY() function in an excel worksheet which is accessed using PowerBuilder. Now I have to open the excel file just to update the TODAY() function, and this method is a bottleneck in my workflow.I want the contents to reflect on the power builder without opening the excel file.I cannot use VBA macros as excel web doesn't support that
Get&Transform / Power Query stuck on load to Data Model
Hi all, I have been working with Power Query / Get&Transform for several years now, and have now run into a problem I have never encountered before. What I am trying to do is load a new query to the data model. Normally this is no problem, but the last few days even the simplest of queries (e.g. 5 rows, no edits) get stuck. When I load a query it returns the "xxx rows loaded" message in the Workbook Queries pane, but the loading wheel (the green dots) is still going in a circle. When I check the data model the data is also not visible. So far the loading has never stopped (unless I cancel the query) since I encountered this problem. The size of the query does not matter, I tested it with a very simple query of 5 rows, and this does not load either. If I change the load to options I can load the query as connection only without any issues. Loading as a table at times also results in the eternal loading issue (even though it does generate some of the data). Thus far I have not encountered the issue while refreshing/editing existing queries. I've uninstalled/reinstalled office multiple times, even using the office remove tool, and this solves the issue for a short period (sometimes a few days, other times a few hours). I have not been able to discover any kind of consistency in when the problem starts to happen ( e.g. refreshing a specific query or something), but once it happens I can no longer load any new queries. I am using office version Pro Plus 2016. I've checked all over the web, but have not seen any other posts regarding this eternal loading issue, so I hope one of you can help me figure this out. Kind regards, Stephan
