Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Need Excell direct link with ERP Database
Need Excell direct link with ERP Database ,so we can get access to accounting balance on excel directly without need to export report on exc
2 votes -
metadata
I would love to see the Get Data from Folder allow me to get metadata from the files in the folder. Such as metadata from Audio(MP3), Photo(Jpg) or Video(MP4, MKV), etc. This method currently gets me the File Name and Size but that is about it useful.
This would allow a user a method to create a list of all their files with data that's useful and important and keep it up to date with a click.
2 votes -
Give me function like importrange or let me can use data from other excel online page
Hope can add function like google excel's "importrange" or like Excel offline's External reference that I can use data from other excel online page and vlook up
4 votes -
In einer neueren Version von Excel möchte ich den dynamischen Datenaustausch (Dynamic Data Exchange, DDE) in Kombination mit dem Seriendruck
In einer neueren Version von Excel möchte ich den dynamischen Datenaustausch (Dynamic Data Exchange, DDE) in Kombination mit dem Seriendruck-Assistent mit Schritt-für-Schritt-Anweisungen in Word verwenden. DDE soll wieder von Excel unterstützt werden. Ich möchte, dass dieses Feature (DDE) bei der nächsten Version von Excel berücksichtigt wird,
5 votes -
User can sequence the query for Refresh
I'm importing data in 3 different tables and using that table data, I've created Pivot Tables. When I click on "Refresh All" its refresh pivot tables first and import fresh data later. This result in to Pivot table showing same data instead of updated table data as they are refreshing before query import data from external sources. Because of this sequence of refresh I've to click again on "Refresh All" button to update Pivot data. If user can manage the sequence of refreshing Tables & data (First let query import all data & later Pivot Table refresh data) so that…
8 votes -
Get Data from table without Totals
I have a table with a summary, when I get/import this table in other Excel file, it imports summary as data, that is wrong. Please correct that issue.
3 votes -
turn off automatic date conversion
Opening scientific data in excel for review or analysis purposes is a nightmare in Excel. Some values, gene names and other text automatically transforms into dates and then the data is corrupted. Changing cell format in this case corrupts the data even further and there's no way to return to the original value/text, since the data corrupts when opening the file. This is the worst functionality in Excel and I don't know anyone who benefits from the automatic transformation of dates. Please the date transformation optional setting for those who might need it!
43 votes -
Add short month name and short day name in Power Query
In Power Query, you can convert a date in year, month, day, first day of the month, day of the week, .... You can also convert a date in month name or in day name.
But there is no option to convert a date with the short name (Jan, Feb, Mar, ...) and the same for the day (Mon, Tue, Wed, ...)
Is it possible to add these options on the ribbon?
34 votes -
Allow Excel Data / Get Data / From File to work with Onedrive cloud files so that users can share the one data table as a central database
It took us three months for Microsoft support to understand this simple request and conclude it is a "functional limitation" with current Excel and the linking of data only works on local c-drive, not over a shared onedrive folder between colleagues - sigh.
Here is the summary of steps:
- Open an Excel file.
- Click on Data.
- Click on get Data.
- Select from File.
- Select From Workbook.
- Imports an Excel workbook which has table inside it and load it to this file.
- Once done, upload it to OneDrive from where this files gets to be shared.
- Go to Shared tab for…
3 votes -
EXCEL DDE
Resulta muy importante mantener el uso de DDE en Excel. Para poder utilizar combinacion de correspondencia con Word.
El tipo de combinacion DDE se encuentra presente en Excel desde sus origenes. Es el unico tipo de combinacion que mantiene los formatos de numero tal como se reflejan en el Excel para su combinacion en un formulario de Word.4 votes -
Enable autosave when inserting objects to workbook
I inserted objects by clicking Insert> Object> Create from File> Browse...> Choose a file such as Word document, PNG/JPEG image, PowerPoint document, Excel document, iqy file, PDF file and some other kinds of documents> OK> Save the file to OneDrive.
All the results are that the error message appears, so if users insert objects (not only PDF files) in Excel workbook and save it to OneDrive, the autosave will be disable. So I would like to request autosave should be work when I insert object.5 votes -
Stock Data Type can't find mutual fund
The stock data type should recognize all stocks and mutual funds. The capability indicates it is powered by Bing; Bing recognizes the ticker symbol. Specifically, the mutual fund 'FSHCX' - 'Fidelity Select Health Care Services Portfolio' was not recognized in my first experiencing trying the feature.
2 votes -
Improve Queries and Connections Task Pane
Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions
My issues:
The pane does not remember its size
It opens really narrow on my system, displaying only a (very) small part of the connection and query names so my first action every friggin time is to drag it wider.No multi select
in the old connections window you can control or shift-click multiple connections to delete them. For maintenance this is a very useful feature I miss regularly.It isn't application-centric
If I open a new workbook with…
30 votes -
Excel Data Types.
Excel Data Types.
Thank you, I really appreciate the Stocks Data Types.
My only suggestion would be to include notes and debentures and/or a more detailed search. I was unable to find certain stock from the TSX and London.
Thanks2 votes -
Ability to Convert from PDF to Spreadsheet
As a student, there are so many files that I get in PDF format that I need to find information in and excel is the best way to do it! As an example, for an assignment recently I had to find different phone numbers and there were 17 pages! Additionally, it would also be handy to managers ect who get forms in PDF format to be able to convert them to excel.
3 votes -
2 votes
-
Please optimise Power Query UI perfomance
Guys, why you call every previous step for every next step in Power Query, while refreshing this query preview? I.e. if I am at Get&Transform UI and click "Refresh Preview" on a Query where I have 3 steps, PQ calls step one 3 times, and step two 2 times. But if you call step one, you can use the results of the call for the next step AND for showing its result in the UI as well. Why you call previous steps so much??
Moreover, you inevitably call all the Queries, used in the refreshing query from p.1. So in…
2 votes -
Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns
Using Power Query to Unpivot other columns is an amazing feature but it automatically removes nulls and errors.
Add a drop down down (maybe an advanced option) to Unpivot Other to allow the keeping of all items
23 votes -
Allow interaction with Excel while in Power Query
Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.
The current behaviour makes it very difficult to do things like the following:
-Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
-When we have a static table in Excel and are trying to build a query that lands an…253 votesHi Ken,
Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.
thanks
Ashvini Sharma
Lead Program Manager
Excel -
Suppress Native Database Query Prompts
Excel security options in Power Query to suppress the Native Database Query prompts when refreshing the data connections are lost when another user opens the workbook.
Trying to roll Excel workbooks that use Power Query within organisations is problematic as there appears to be no way currently to disable these prompts for the end users.
2 votes
- Don't see your idea?