80 votes8 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
They updated Power Query for Excel on Office 365 1907 (compilation 11819.200002 insider build) and added a currently deactivated Power BI source. Maybe they are up to something, but I couldn't find a related M function for that option.
Never heard of this before but apparently when you don't use logical operators with numbers, it always returns TRUE.
Same happens in VBA and older versions of Office which I think is weird.
4 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Maybe something more like DAX Divide function.
Description from MSDN:
Performs division and returns alternate result or BLANK() on division by 0.
DIVIDE(<numerator>, <denominator> [,<alternateresult>])
1,177 votes908 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!
They just changed the way that users see multiple excel books.
Excel 2016 behaves exactly the same as in older versions, the only difference is that you can see multiple books at the same time now.
I personally love this new behaviour because I use multiple monitors, and now I can see a spreadsheet values while modifying another one.
I do believe that your problem must be that you open new books by right clicking and selecting the app, which makes excel to be opened in a new instance, but this happened in older versions too.
99 votes13 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
256 votes20 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.
Lead Program Manager