Provide an Excel function that date stamps a row when any change is made to data in that row (other than the date stamp column). This is exceptionally useful when maintaining membership data, inventory records etc.

In the desktop version of excel,

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)

is the only way to find the current sheet name. On Excel Online, the function CELL does not work.

In the desktop version of excel, I can reference a cell from another sheet in my formula simply by clicking to that tab and cell. For example to make ='Sheet2'!A1 , I simply have to hit "=" and then click to the tab and cell I want in the formula.

In Excel Online, it is not as user friendly. In order to achieve that reference in a formula, I would need to type out the entire formula, in the process clicking back and forth to remember which cell I am referencing.

Enable VBA for Excel Online. Others have suggested a scripting language like google sheets has (which is javascript). No, keep it VBA.

Not so much an idea as a fix. MS should make it so you can correct your timezone (time and date) within Office Online so time and date related formulas are correct.

Name a range in Excel Online and make available to use in formulas in other workbooks

Please port name management to Excel on the web, so that we can name tables and ranges and use the names in formulas.

Add ability to define named ranges on the web. Excel is useless to me without this. :-(

In standard Excel you can Ctrl+click and select various cells at random and see the sum or average of these cell value. Online only allows sequential cell selection for this. Is this coming?

I would like to be able to attach PDF files

Excel 365 online not very useful without a show formulas method.

While copying and paste excel sheet on online sheet, formulas are not reflecting in online sheet

Array Formulas should be able to be calculated online.

To recreate the Query function in Google Sheets requires the following formula in Excel:
{=IFERROR(INDEX('General Ledger'!E$2:E$1000,SMALL(IF('General Ledger'!$C$2:$C$1000='102'!$B$1,ROW('General Ledger'!E$2:E$1000)-ROW('General Ledger'!E$2)+1),ROWS('General Ledger'!E$2:'General Ledger'!E2))),"")}

Already quite cumbersome when compared to Google Sheets:
=QUERY('General Ledger'!A2:H , "Select A, B , E, F, G, H Where C =" & B1)

But when it doesn't even calculate in Excel online it's pointless as a Google Sheets replacement! I'm trying to build a basic accounting spreadsheet that can be used online that integrates with other online features I'm building.

When using a formulae with row cell references in a conditional format copying the cell's format down should adjust the conditional formatting formulae's cell references accordingly to use the new row's cells unless I have the $ symbol.

Would really like to have the custom sort feature on the online version.

Hi, i have been using Office 365, the issue with Excel online is that its functions and formulas are not working accurately. while i run sum function and selecting cells one and another so it does not select it, rather then select the whole range.

hope to see fixed this issue.

Regards,