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]

Hi all,

The ability to “keep a sheet on top or in a separate window” is available today. To accomplish this, head on over to the View ribbon and select “New Window.”

That will give you a second (or third, fourth, etc.) window that displays the same workbook, and you can independently navigate sheets, etc. to keep those you want ‘always visible’ available.

It’s a bit different interaction paradigm than the browser or IDE (SSL Mgmt Studio) where you “drag a tab”, but it accomplishes the same result.

Cheers,
Dan [MS]

Great news – we’ve introduced the SWITCH function to Office 365 subscribers. If you update today, Aug 19, 2016, (if you haven’t already), you should now have this in your arsenal.

https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e

Cheers,
Dan [MS]

Updating the status here – we’ve actually got something in the works that should be out soon. Stay tuned!

Best,
John [MS XL]

Thanks for your feedback! Just a note to let you know that we’re working to promote the usage of Excel User Voice sites through customer connection channels. If you hear someone asks “Will [feature x] ever be built in Excel? I really need it”, please immediately send them to http://excel.uservoice.com/ and ask them to submit their idea or else vote on it, if it already exists.

Hi all, the original issue reported in this thread was due to Win10 changes in Accessibility. The fixes for this have been released for Excel 2013, Excel 2016 and Office 365 subscribers in March.

For more information, this thread has the discussion: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-filtering-problemmatic-after-windows-10/f6f34982-d4e0-47b3-bd37-772fd51e0ff3.

thanks
ash

Ashvini Sharma [MS]
Excel

2016-07-01 ====

Good news – as of the June release, we’ve completed work on this feature.

Cheers,
Dan [MS]

== November 2015 ==

Hi Teo,

Thanks for logging this request. We’ve started working on several items to improve performance of Excel with SSAS, can’t wait to release them and get your feedback!

ash

You can do this with the TEXTJOIN function, which was added to O365 Excel several years ago.

We actually support this feature in versions of Excel back to XL 2007. Here are the steps.

1) Select the chart
2) from the chart “Design” tab in the ribbon click on the button “Select Data”
3) In the dialog, click on the button called “Hidden and Empty Cells”
4) In the dialog, check the box called “Show data in hidden rows and columns”

Thanks,
Scott [MSFT]

This has been re-fixed, and the pen should work again in Excel.

Cheers,
Dan [MS]

Black theme is back. Update to the latest update for Office 2016, and you can choose Black Theme as one of the options.

Cheers,
Dan [MS]

Please try the new RANDARRAY function, which has more options than RAND and RANDBETWEEN.

Great news, that exact line of code you have there works just fine to apply borders, so you should be good to go.

Range(“J44:M44”).Borders(xlEdgeTop).Weight = xlMedium

Cheers,
Dan [MS]