Excel for the web
Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a thirdparty 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.

Linking of excel sheets in multiple files using formulas in sharepoint.
Working in single file is a basic thing. However linking of multiple excel files through formulas are not present in sharepoint. For example VLOOKUP(), SUMIF(), MATCH() e.t.c.
1 vote 
1 vote

Libre Office has a function fairy, complex functions and equations are much more editable
there would be no need for macro solutions if the calculation formula could be embedded in a car filter function on the worksheet. Only the carfiltered results would be subject to the calculation of the specified function and the relevant one.
Although there is a SUBTOTAL function, only a few functions are capable of doing so.
Függvénykód
(also hidden values) Function code
(omit hidden values) Function
1 101 AVERAGE
2 102 WORKS
3 103 WORKS2
4 104 MAX
5 105 MIN
9 109 SUMLibre Office has a function fairy, complex functions and equations are much more editable
1 vote 
calculation of car filtered data with car filter function
there would be no need for macro solutions if the calculation formula could be embedded in a car filter function on the worksheet. Only the carfiltered results would be subject to the calculation of the specified function and the relevant one.
Although there is a SUBTOTAL function, only a few functions are capable of doing so.
Függvénykód
(also hidden values) Function code
(omit hidden values) Function
1 101 AVERAGE
2 102 WORKS
3 103 WORKS2
4 104 MAX
5 105 MIN
9 109 SUMWith this solution, car function results could be calculated with any function
1 vote 
ability to see number of filtered rows
be able to see how many rows are filtered.
1 vote 
Request to please add formulas name manager in this format of Excel(web)
Request to please add formulas name manager in this format of Excel(web)
2 votes 
1 vote

Add Query (See Google Sheets for functionality)
Query is a lot easier to use when performing aggregations than VBA.
=Query({Shee1t!B2:E}, Select Col1, Col2, Sum(Col4)/1048576 Group By Col1, Col2 Where Col2 IS NOT NULL Label Col1 'Cluster', Col2 'Index', Sum(Col4)/1048576 'Size (MB)'
> Would take data from Sheet1, cell range B2 upper left to last row of E), and for each combination of values from Col1 (matching the first column in the original cell range, which is column B ) and Col2 (column C) sum the corresponding values from Col4 (column E).1 vote 
Link to another tab in same sheet appears to be disabled in a shared file. Tried on PC and Mac. Commonly done in multitab spreadsheets
I have a multitab spreadsheet that is shared in onedrive. Formulas need to link to data in other tabs. It's a common function used to create a total "tab" from several subtabs. Example: Global Sales tab summed from several Regional tabs.
This appears to be locked when the sheet is shared. There is no clear way to unlock it and no clear help on doing so.1 vote 
Excel Data Group Need to Function in Protected sheet
In a Protected Work sheet, Data Groups of Columns & Rows is not working.
I like to suggest, We need to have Multi User & Multi Function password Protection based on user requirements
1 vote 
Function Library (book icons) in the Formulas Tab
Basic and intermediate users may be happy to see all the book icons in the Formulas Tab (Function Library group) as we have in the desktop version, to help them to find which functions can be used. Even the mobile version has the categories there... This would be welcome on the online version too.
4 votes 
LET function
By when can we expect LET function to be rolled out in excel web? I understand that the function is still in beta and currently only available to a portion of Office Insiders but still I haven't faced any issues so far in the beta version and it saves a lot of time in writing long formulas which use repetitive arrays and calculations.
My request to the MSFT team is to come out with a basic version of LET function for excel online even if it is not perfect.
1 vote 
Expand The NLP "Ideas Function" To Create, Manipulate And Delete Data, Not Just Summarise And Visualize Data
Today, under Excel Ideas, you can enter in a question about your data using NLP (writing plain English without formulas). However, there is no way to use Ideas to create, manipulate or delete data. For instance, I know I'd like to pivot and condense a complex dataset, but I do not know how to formalize this using formulas.
2 votes 
ERROR in TODAY FUNCTION
=TODAY() is giving 04/05/2020 still even though time is 05/05/2020 9:51
1 vote 
New formula for pasting value or multiple but in a cell referenced in the formula.
Create a formula which drives a function and shows the value in target cell.
1 vote 
New formula for pasting value or multiple but in a cell referenced in the formula.
Create a formula which drives a function and shows the value in target cell.
0 votes 
ok sir
ok
1 vote 
In Online excel formulae on different should be applied . As of now have to keep both reference data in single sheet .
Online excel to apply vlookup formula , data is to be maintained in a single sheet to apply the same . Data if present in multiple sheets , then formulae should be applied irrespective of data present in single sheet .
1 vote 
Be able to link cells between excel files in teams.
Be able to link cells between excel files in teams.
6 votes 
I suggest for a subtotal function in the data tab.
its easier to use the subtotal function in making excel data.
3 votes
 Don't see your idea?