Excel for Mac
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
-
STOCKHISTORY
For days when prices are not available such as hols - instead of a n/a please use 0. Whilst trying to do an average of stock history prices is there is a n/a int eh column no formulas work as there is a n/a in a cell
1 vote -
do not convert space char(32) to Non Blanking Space char(202) on data import/paste
Excel for Mac converts 'regular' spaces [ char(32) ] to Non Blanking Spaces [if using MacOS Roman ] which is char(202). Those characters are not removed by TRIM. The conversion is extremely problematic for data import / export and data clensing. This behaviour is platform, character set specific. I've seen it also happen on Windows where the regular space, when using UTF-8, is converted to Char(160).
1 vote -
1 vote
-
Make decimal separator selectable
In Excel Windows you can choose between point or comma as decimal separator. In Excel Mac you cannot. About half of the world uses comma like Sweden and imported documents from the U.S. and some other countries always cause a lot of problems. So please let me set point or comma as decimal separator for each document.
The ideal solution would of course be a new separator that would be standard all over the world and Microsoft together with international bodies.
https://en.wikipedia.org/wiki/Decimal_separator2 votes -
1 vote
-
Include connectivity to cryptocurrency price updates
Include dynamic connectivity to cryptocurrency price updates via API
1 vote -
1 vote
-
Excel for Mac change defaul CSV import separator
Every time I open a CSV file on my Mac I need to reformat the file as the default separator is a TAB. I suggest including a setting to change the default CSV separator configuration. Ref.: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-for-mac-permanently-change-text-imp-wizard/59a02758-a758-4e13-9b0c-6e748fd5a43d
1 vote -
Allow me to upload my excel worksheets to my drive multiple times.
Allow me to upload my excel worksheets to my drive multiple times. Please.
1 vote -
Increase capability of STOCKHISTORY function
The STOCKHISTORY function is great for getting the price history of one stock. Three suggestions:
1. It could offer more utility if it could get the stock history for multiple stocks, and align the values with respect to dates. For example, if I wanted monthly close values for 8 stocks over a 4-year time range, it could return an array of 9 columns (1 date and 8 stock values) and 49 rows (1 header row and 48 monthly data rows).
2. In addition to "daily", "weekly" and "monthly", it would be nice to have interval choices of "quarterly" and "yearly". …3 votes -
Stock quotes
I have created a spreadsheet with stock quotes linked to it, I have discovered that when I protect the page the stocks will no longer update unless I unprotect the sheet. I think I could probably unprotect the individual cells and then it should work, but that would prevent the page from being protected from kids that may wander onto it.
1 vote -
Get Excel to work with Yahoo Finance Web Page doing Web Query
I’m **** a Web Query on Office 365 (Excel) for Mac using Yahoo Finance to get my data to insert into my Excel spreadsheet. Yahoo Finance webpage has 9 tabs. Only the Summary Tab works for my Web Query. When I use the Performance Tab which is the one that has the data that I want for my Web Query, it doesn’t work. This is not password protected as it just another tab on the Web Page. Can the MS Developers get this to work.
The "performance" tab on Yahoo Finance has the financial data that the "summary tab" does…1 vote -
Get Excel to work with Yahoo Finance Web Page doing Web Query
I’m **** a Web Query on Office 365 (Excel) for Mac using Yahoo Finance to get my data to insert into my Excel spreadsheet. Yahoo Finance webpage has 9 tabs. Only the Summary Tab works for my Web Query. When I use the Performance Tab which is the one that has the data that I want for my Web Query, it doesn’t work. This is not password protected as it just another tab on the Web Page. Can the MS Developers get this to work.
The "performance" tab on Yahoo Finance has the financial data that the "summary tab" does…1 vote -
SQL ODBC for Excel Mac with M1 chip
Hello,
It seems SQL ODBC driver is not working (or even included) in the latest version of Excel for M1 chip.
Would you have visibility on when this feature would become available please?
Thank you,
vince1 vote -
Ability to import xml files
We have to jump through hoops to import a xml file in Excel for Mac. What I can find is basically not understandable. I am paying a yearly subscription and expect more than this. Once I learn how to use Numbers and Pages I will be cancelling my subscription. I will learn how to use those before I continue struggling with this.
1 vote -
Add Apple Card to Money in Excel
I cannot seem to add the Apple Card to Money in Excel (probably Apple's fault), but they have recently made it possible to access my account without being forced to use my phone, so maybe its possible now.
4 votes -
Add The Federal Thrift Savings Plan to choices for investments in Plaid
I can not include my account in the TSP account to the budget program
1 vote -
1 vote
-
Data Types Missing for MacOS (i.e. Food, Chemistry, Element, Space etc.)
Data Types for MacOS are only Stocks and Geography. For Windows there are more data types available. Why is that? Is there a fix anyone knows? I am running the latest MacOS and Excel Office 365. Any help is appreciated!
1 vote -
Importación de tablas de páginas web
Excel para Mac no puede importar datos de páginas web. Debería ser posible. ¡Gracias!
1 vote
- Don't see your idea?