Good news! On Windows, you can now scroll right and left using a mouse with a scroll wheel by holding down CTRL+SHIFT. If you move the scroll wheel up, it will scroll your sheet to the left, and scroll down to go right. On Mac, you can just hold the SHIFT key to do the same thing.

To see all the suggestions we’ve completed, please see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/filters/top?status_id=1406092

We have addressed the topic of this suggestion by bringing back the legacy comments as notes and included the edit comment action as “edit note” in the right click menu. Also, this topic has multiple suggestions, so if for any remaining suggestions which are not covered by the update to reintroduce legacy comment editing, please open a new suggestion. Thank you.

Thank you all for your feedback regarding the new AutoSave functionality in Excel.

We’ve been working to better enable collaboration and AutoSave is a key component that. While it can take some getting used to, AutoSave helps users feel confident that their work is being saved. This is especially evident when working with other people, but it also helps when you’re working by yourself.

We understand that you may need to turn off AutoSave for some workflows, so we are excited to announce that it is now possible to turn off AutoSave for a particular file as well as to change whether AutoSave is or or not by default.

For instructions on how to do this please see here: https://support.office.com/en-gb/article/what-is-autosave-6d6bd723-ebfd-4e40-b5f6-ae6e8088f7a5#OfficeVersion=Windows

This functionality is currently available to O365 subscribers.

We hope you continue to leave feedback on Excel to help us improve.

Thanks,

Pallavi Hukerikar
Excel Program Manager

Thanks for the suggestions folks! We’ve added [if_not_found] as the 4th argument to XLOOKUP. The thinking is as follows:

It’s a reasonably common use case
The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.
- Joe McDaid [Excel]

Thank you all who voted! And we hear you loud and clear and we have been working hard at improving Excel 2016 stability on-going with every monthly release with our January monthly channel release at historically low levels based on our internal measures.

Moving forward, please send us feedback from within Excel, which includes actionable crash information we monitor regularly. Once Excel reboots from a crash please goto File → Feedback → Send a Frown, provide information on what Excel specific action you were doing when the crash occurred and press the “Submit” button.

thanx,
Prash [MSFT]

Hi all! I am happy to announce that recently we have released From PDF data connector in Excel which allows you to import and work with data from your PDF documents. Refer to this blog post for more information:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-data-import-from-pdf-documents/ba-p/1569202

Guy Hunkin
- Excel Team

Thanx for creating and voting on this folks!

You should see this issue fixed starting with the latest Windows 10 Preview 17133.73 build update on 4/10 (https://blogs.windows.com/windowsexperience/2018/03/27/announcing-windows-10-insider-preview-build-17133-for-fast/) as well as latest Excel Monthly channel 1803 Build 9126.2152 update on 4/11 (https://technet.microsoft.com/en-us/office/mt465751.aspx).

Please let us know if you find this still not fixed with these builds (and later).

thanx,
Prash [MSFT]

Update – 2016-03-07

Hi All,

Just wanted to let you know that we’ve completed adding new =CONCAT and =TEXTJOIN functions to Excel 2016 (as part of Office 365 – builds 16.0.6528 and later) that should do what’s been requested here. You can read more about it on our blog:

https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

Cheers,
Dan [MS]

In Office 2016, we released 6 new built in chart types: Treemap, Sunburst, Histogram, Pareto, Box & Whisker, and Waterfall. Checkout the following link for the top new features in Excel 2016. https://docs.com/ExcelDemos/7981/excel-2016-top-features.

However, there are several other feature requests wrapped up in this post. Please enter those as separate items so that we can respond to them individually.

Thanks,
Scott [MSFT]

A little bit late updating the status on this suggestion, but we’re happy to say that Power Query now has Intellisense when using the Advanced Editor and the query formula bar. If you don’t see it already, just go to File > Options and Settings > Query Options > Power Query Editor, and enable M Intellisense.

2016-04-19

Hello all,

Just wanted to let you know that we’ve released MAXIFS and MINIFS to Excel as part of Office 365. If you’re a subscriber you should already have (or see soon) these functions in your arsenal.

Cheers,
Dan [MS]

2015-11 ========
Hi there,

Great news – we’re working on this! Actually, we’re working on MAXIFS and MINIFS – even better :-)

Cheers,
Dan [MS]

We’re happy to say that the UNIQUE function is available for O365 subscribers. Please see this article for more information – https://support.office.com/article/UNIQUE-function-c5ab87fd-30a3-4ce9-9d1a-40204fb85e1e

Over the last few years, we’ve improved our ability to detect and fix performance issues significantly, and as a result we’ve seen performance improvements for users as well.

We intend to continue working on performance, but we’re marking this suggestion as completed.

Steve [Excel team]

Update (July 25)

Hi again Erik,

This issues should be fixed in our August 2nd update.

If it isn’t, pls reach out to me directly at myfirstname dot mylastname at microsoft dot com.

Thanks again for raising it.
ash

Program Manager
Excel

—

Hi Erik,

Boy, you’ve been having quite a saga here. Even though this site is for new requests, appreciate finding out about this. I’m reaching out to Brian to understand what’s happening so far.

thanks
ash [Microsoft Excel]

Hi Srikanth,

As Yigal mentioned, PowePivot is now part of many Excel 2016 versions, as noted here: https://blogs.office.com/2015/09/18/new-ways-to-get-the-excel-business-analytics-features-you-need/

Hope you’re enjoying the new version of Excel!
dan [MS]

Changes to AutoSave settings should not change on update. This issue was raised when the changes to AutoSave were made. This should no longer be a problem. If you experience further issues go to File > Feedback and send us more information.

This is available on the Help tab of the ribbon. Just click “Suggest a Feature”.

Hi all, great news!

32-bit Excel 2016 build 16.0.6868.2060 onwards is enabled for Large Address Aware. This will allow 32-bit Excel 2016 to consume beyond 2 GB virtual memory… up to 3 GB on x86 Windows and 4 GB on x64 Windows. We believe this should help alleviate some of the out-of-memory related errors seen before when memory is constrained for 32-bit Excel, for more details see KB3160741 here https://support.microsoft.com/en-us/kb/3160741

Also – I should note that this idea covered two topics – more memory for 32-bit Excel, as well as making 64-bit Excel the default/standard. I’ve created another idea on UserVoice that you can vote on if you’d like to see 64-bit Excel as the standard: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13795662-create-a-64-bit-version-of-excel

Cheers,
Dan [MS]