This applies to both online and desktop version. When values change in a row in a table, in some cases information about when the change was done is required (e.g. when a workbook is shared and updated manually by several users). This can be solved by an event in VBA, but it can also be solved by using a formula and 'Enable iterative calculation'. The last option requires changing a application-wide option in Excel settings, if this could apply only to a workbook at least it would be possible to create a solution that works for all users using a shared workbook.

There are several functions that don't work the same in the online version vs desktop. Below are a few that are particularly frustrating to me so far:

~ Paste/Formatting - When pasting into the online version, the format doesn't stay.

~ Sorting - There are very limited sorting options in the online version.

~ Copying data. I have about 300 lines of data that's about 10 columns wide and am unable to copy it so that I can paste it into another document and sort it the way I need (since online version has limited options for sorting, as mentioned above). I get the following error when I try to do so: "The data you've selected is too large. Try selecting a smaller set of data."

Expand the “All Scripts” functionality to create an Explorer/Admin experience within the Excel app.

See attached Screenshot 1.
Currently when the list of scripts is displayed, see screenshot 2, it lists the scripts but there is no associated information along side each script. For example,
• “file size”, KB, MB etc.
• “date modified”, local date format
• “date created”, local date format
• “last ran date”, local date format (and time)
• “duration” - how long it took for the script to run on its previous run),
• “memory last used” - how much memory the script took in memory resources. For example if there is a large table being handled by the workbook.getTables function then the size of that table would contribute to this total “memory usage” metric. Later, in the script, if it uses the getRange function then the size of that range, too, would add to the total-memory-used value.

• “Called by a Flow” – Yes/No

• “Name of Flows that have used this script” – displays a drop down list of Flows each of which is a hyperlink to that Flow. Clicking the name of this filed should take user to a page on flow.microsoft.com displaying a pre-filtered list of Flows used in the script.

• “Calls external data” – Yes/No. For example if the HTTP GET function is used in the script.
• “On/Off” - change this attribute to switch on or off the script.
• “Script Recommendations Available” – Yes/No. This should, perhaps, navigate (be a hyperlink) to another pane displaying any available, specific, recommendations to improve the performance of the script.

Each of these fields should be modifiable so that their order can be changed and formats (i.e. for dates) and actual values for some.
See attached Screenshot 2.

All of the above information and functionality should, also, be available via an Admin button on the Automate Tab. See attached Screenshot 3 :
This would a web page linked, perhaps to the “Microsoft 365 admin center” web page. https://admin.microsoft.com/AdminPortal/ For organisational users (non-admins) they cannot access this page when logged into their organisational Tenant. This means there needs to be, either, a new Office App called “Office Scripts Admin” (accessible via office.com) or a new web page providing the above explorer-like functionalities.