Mac users desperately need full access to the "get and transform" feature. We are not able to retrieve data from table or file which limits our use of the function.
Thanks

There are many cases where I do analysis on one data segment and then want to repeat it with another data segment. I want to copy the sheet I just finished, put in the new data and have the next sheet done. I can't because the graph that shows the first data visually prevents the sheet from being copied.

Provide a way to create a Venn diagram so that the circle sizes approximate the different magnitudes of the data items. When they are all the same size, you can only see relationships, not the importance of them.

When I save changes made to a newly opened existing (from OneDrive, via File menu) spreadsheet, I'm not permitted to save for edit collisions. I can make OneDrive configuration changes that prevent these collisions (isn't that the POINT of OneDrive for Office- allowing multiple users to edit?), but that causes problems in other ways.

FIX the problem, don't just create an un-reliable work-around.

Current Scenario
While using the dynamic arrays formula in data validation list is not returning the arrays values, we need when enter the dynamic arrays formula in a column then call the arrays using # in data validation

Requested Solution
Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.

You need to complete rewrite the code. Excel for Mac is the worst Microsoft product ever.

Conditional formatting which uses named ranges in the condition, can't be copied between two workbooks. It can be copied only within one workbook.
Identical conditional formatting that uses unnamed ranges can be copied between workbooks without a problem.
This bug is in versions 16.35 and 16.37.

PLEASE FIX!

Enable the creation of USERFORM in eXCEL 16
Please take this request into account and enable the functionality of creating userforms in EXCEL from VBA. It is a very important functionality.

I compared the "Manage Rules" feature on Windows and Mac, I found that the difference is Windows has the "Apply Rule To", however, Mac doesn't have it.

I want to see my previous data sometimes even if I delete it, so even after I save a document, I want to go back and view what I put originally so I don’t have to re-enter that idea if I want to go back.

Hi Team,

Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

It is On MAC OS

Hi Team,

Since the upgrade of 2016 MS office in excel Autoformate feature is not available. Could you please tell me how to get it right.

It is On MAC OS

配列数式を　組む際に、
　・セル間配列数式値の　受け渡し、
　・ネスト間配列数式値の　受け渡し、
此等において、

ご存じの通り、
阻害条項が　横たわっており、

連れて、
名前定義を　介したり、
INDEX構文を　持ちいたり、
等、

阻害への　特殊な、
対応が　求められます。

又、

OFFSET構文等の、
索引関数の　結果を、
上位ネスト関数に　引き渡す際にも、

かなり　以前から、
不具合が　見られるように、
なっていますし、

他にも　有る、
可能性も　横たわっています。

一方、

もし　此等を、
VBAで　なそうと、
する場合、

ループ等での　対応が、
一般的です。

ですが、

此では　オブジェクトタッチ数が、
飛躍的に　増え、

連れて、
必要処理時間が　飛躍的に、
増加するだけでなく、

プリセット機能である　シート関数の、
有用性を　殺し、

併せれば、
Excel　其の物の、
価値を、能力を、
毀損しています。

Excelの、

持てる　能力の、
全てを　毀損させず、
余す事なく　発揮させるためにも、

配列数式への　改善を、
図っては　如何でしょうか、

ご検討を　願います。

Nowadays many scientific papers require the bar chart showing the mean of the import data with error bar together with each data point being displayed. Only Prism can plot this kind of bar chart. Would Excel improve its system so that it can include this property in plotting bar chart in the coming future?

The current Office 365 Excel (Mac) ribbon design should be 'revised' to previous versions. The font and icon sizes and styles are very difficult to read, especially for people with bifocals or altered vision. E.g., the 'Fill Color' icon used to look like a paint can and now appears as a faint tin can. Font sizes are too small, thin, faint. Just because you can change something does not necessarily make it better. Perhaps Office designers should be required to read Don Norman's design books.

Not able to find the feature 'From web ' in mac unlike windows os

As of March 2020, I can change the order of data series for a chart either by using the arrow buttons in the Chart Source Data dialog or by changing the order value in data series definitions in the formula bar; but (at least for line charts) this does not alter the data series order in chart legends.

Search results for "change Excel chart legend data order" indicate the Windows version matches the legend data order to the chart data order when changed, as it should. Need to do that for the Mac version, too.