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

https://support.google.com/docs/answer/3093340?hl=zh-Hant

Recover exchange server edb file data through the help of sifo systems edb to pst software .This edb recovery software genuinely restore exchange server edb file and as well as make its recovery from viruses ,etc .
It has nice working support with all version of exchange edb file that are edb 2016,edb 2013,edb 2010,etc .

Go for free download of software ,click here :- https://readthedocs.org/projects/sifo-systems-exchange-server-recovery-software-to-recover-exchange-edb-file/

I find that when a range of data is linked (copy from Excel and then right-click in Word to link and keep source formatting), the operating speed of Excel decreases SIGNIFICANTLY!!! as the links to Word increase by quantity (many) and complexity (greater range of data) when both the linked Word doc and Excel worksheet are open, even though the use of computer memory is less than 30%. this seems to be a limiting capacity of the Excel and Word program rather than a limiting capacity of the computer.

Sheet1 has a table of values that I want Excel to put into Sheet2 based on certain criteria automatically. As in, if ColumnB on Sheet1 reads "Yes", then ColumnA of that row gets added to Sheet2. (i.e. "=IF(Sheet1!B:B="Yes",Sheet1!A:A,""). Thus creating an auto-populating Table in Sheet2 without using a macro.

Relative paths within OneDrive - my documents folder is stored in OneDrive on my PC, so all items are synced. If I have a spreadsheet with external links, then it should work in Excel Online just like in Excel 365 on Windows.

Ideally, DSN connections (e.g. MySQL db files), refresh of Power Query when opening in Excel Online etc would also work regardless of platform, but I realise that is tougher

I think the ‘Advanced business analytics features’ should be also available for Office 365 Business Premium subscribers. I do not understand why this comes as a difference between ProPlus & Business users. Business Premium users are widely using SharePoint and incapability of importing data from it for them does not make sense to me. The difference in size of company you work for should not mean you are stuck with less privileged product.

There should be an easier way to name your Spreadsheet as a Header:Example: Insert name for Header.

In general, it would be good to have one version of SSAS in both Power BI and Excel.

Entering dates in Parameter of date type is very inconvenient. It is almost impossible to change it, and if you enter a date from scratch, you'll have troubles with year part of a date.

All this is due to autofill function. Please turn if off, or let user do it in Query Options

If you created a Function from a Query, if you change the Query, the Function is changed as well.

If you copy both of them to another workbook, this "relation" is broken.

Please keep relation between a Query and a Function, created from the Query, when copy both.

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

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.

Please recognize when a csv File is in Unicode and then load it properly when opening it. Right now it's a huge hassel to open unicode

Please recognize when a csv File is in Unicode and then load it properly when opening it. Right now it's a huge hassel to open unicode

Mutual funds are priced once a day. The date associated with the price would be more important that the date and time of the update. The date of the price is available on Morningstar.

When I create a connection with another csv, txt or xlsx file, but for any reason I changed the location, it's brings an error.

It would be great to Power Query have the capability to automatically connect with the same folder.

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.