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

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.

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.

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.

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.

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

I would like to be able to attach PDF files

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?

Enable formula bar size adjustment. Add reliable scroll function within formula bar. Tap cursor back or forward to allow cursor movement between characters in formula bar.

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,