21 votes3 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thanks for the further details on Bullet charts. The Wikipedia article is a good reference. As we plan the next release, we’ll definitely consider this new chart type.
Please continue to investigate. As you can see here - http://peltiertech.com/bullet-charts-in-excel/ - this is an exceedingly tedious task to do by hacking other chart types in Excel.
15 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
that requires doing stuff every time data is brought in or pasted. A formula, once set up, works every time. I can do it with a formula, but it is a long formula using the DATE, YEAR, MONTH, DAY, TEXT, MID, LEFT, and RIGHT functions. Not quick to set up, and I suspect a lot more overhead than if it was just the DATEVALUE() function.
While the method you mention *is* very handy for one time conversions, it does assume the date is in its own cell. That is often not the case if it is copied/imported.
I just found it really odd that Excel supports it in the Get and Transform M Language functions, but not in Excel worksheet functions.
10 votes1 comment · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
11 votes2 comments · Excel for Windows (Desktop Application) » Printing · Flag idea as inappropriate… · Admin →
3 votes0 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
47 votes6 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)
Additionally, if you can post a video of what you’re seeing, that would be a big help for us.
If there is a problem here, it’s definitely something we’d want to fix.
Dan, the Excel 2016 app seems to have a mind of its own when it is opened in anything but full screen. I have a Surface Pro 4 (high DPI) attached to an external monitor (low DPI) so that may be contributing to the issue.
As an example, when I open a file on my Mac, it is *always* the same size. The window size doesn't change from session to session - the exception being is if I opened it on my iPhone and when I return to the Macbook, it is a postage stamp size. :-(
But on Windows, Excel seems to make no effort to remember what size the window was. In earlier versions on Windows this was understandable as the files were all part of the same window, but in Excel 2016, each file gets its own window and that size should be remembered.
This goes for the Mac too. This is especially problematic when you open the file on a mobile device, like an iPhone.
We’d love to get samples of these workbooks that are crashing, along with steps that cause them to crash. Until then, there’s not much we can do without more data.
If you have such a workbook, please create a new idea entitled “I have a workbook that crashes, which I want to send you” and I’ll get back to you with an email address where you can send it so we can take a look and fix the problem.
75 votes17 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for taking the time to post a suggestion Malcolm! We’ll be taking a look at lookup functions. There’s a number of votes on the site for them – I’m not going to merge all of them though because different posts are asking for slightly different things. Please keep voting for the ones you want to see most!
John [MS XL]
Allow negative offsets in the VLOOKUP (and HLOOKUP I suppose) function so we can find info based on data not in the first column of a table, and we don't have to mess with a tedious combination of INDEX and MATCH functions.
5 votes3 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
This would be very valuable. Not only that, but I'd like to see when you open a file in Excel and it says it is read-only because someone is in it, offer to open in Excel Online as one of the options (besides Notify, Read Only)
Agreed. This should not be a destructive edit. I am ok with Excel Online not showing the info, like text boxes, but it shouldn't remove them from the file! Wasn't that part of the point of the new XML formats a decade ago? Data in the file could be ignored by the client if not supported, but not removed from the file.