The automatic formatting of numbers to dates is incredibly frustrating when you dont want it. I am often in a situation where I need to paste a table into Excel, for instance to calculate something from the table. It always happens that some cells in the table get autoformatted as dates and this is extremely annoying. The work-arounds are difficult and cumbersome and I can never remember what they are, so my workflow gets interrupted because I have to google how to do it.

I have very little use for the autoformatting of dates, but i appreciate that some people need it. We need to be able to toggle it off.

I create a lot of workbooks with a repetitive worksheet. For example, a workbook would contain multiple sheets representing a particular day for a project, with the workbook representing the project.

Each of these worksheets have exactly the same formulas and layout, so I create a 'template' worksheet in the workbook, which is then copied to create each of the worksheets.

If I want to change the template, I have to go through each of the copies to manually alter the formulas.

What would be cool is:

1. Create a worksheet as a template
2. Reference that template in copies (Copy from template?)
3. Whenever I change the 'master' template worksheet, all the others change as well.

Guys! Excel crashes every 15 mins or more! It's almost unusable and I have to use it. It ridiculous how bad it is. I shouldn't have had to pay money for this and it makes my job 10x harder. Please fix it. For the amount of money I paid for office (and excel) it should be a working program. Right now Microsoft is a thief of my money and time with the amount of times I've had to redo work with all the crashes. I don't want to hear how you fixed it, just fix it!! (yes, I've updated the program)

I am using Excel for Mac, version 16.30 (always updated to the latest version)

I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

“HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

I have reached out to Microsoft calling the hotline in Shanghai, approaching Microsoft through its Facebook page in Hong Kong, but all failed, as I believe the support team fails to grasp the question (what is a stock, what is an index, etc).

Also requests to speak to technical person with knowledge of the Stocks module remains unanswered.

How is best to approach Microsoft to have this resolved?

I am using Excel for Mac, version 16.30 (always updated to the latest version)

I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

“HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

I have reached out to Microsoft calling the hotline in Shanghai, approaching Microsoft through its Facebook page in Hong Kong, but all failed, as I believe the support team fails to grasp the question (what is a stock, what is an index, etc).

Also requests to speak to technical person with knowledge of the Stocks module remains unanswered.

How is best to approach Microsoft to have this resolved?

To reproduce the issue, setup two sheets with different page layout (e.g. fit to pages, orientation etc). Select both and press print, then press cancel. Both sheets will now have the same print layout. This seems like a bug because:

- This is not expected behaviour as it directly contradicts the documentation for Excel for Mac (see link below)
- Pressing print shouldn't change the design of the spreadsheet and destroy painstakingly setup per-sheet page layout settings that take a long time to fix after this bug has paved over them
- The Windows version does not have this problem
- It is highly counter-intuitive

I have seen cases such as https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10605018-printing-vertical-and-horizontal-worksheets where subsets of this issue have been treated as a feature request and been left on the back-burner for years - that one has been open since 2015 despite people indicating that it is severely impacting their business. It is a bug, not a feature request and is seriously impacting Mac users.

Documentation:

https://support.office.com/en-us/article/print-with-landscape-orientation-in-excel-for-mac-5b26f602-ed29-46bd-992a-52dd9d4770e7

From the documentation:
"Note: Because you can set page orientation on a sheet-by-sheet basis, it is possible to print some sheets in a workbook in one orientation (such as portrait orientation) and other sheets in the same workbook in the opposite orientation (such as landscape orientation). Simply set the orientation for each sheet as appropriate, and then print the entire workbook."