Service ticket number - 1016144833. Stock data is not live.. There is always a delay/lag of 5 to 10 minutes.. Even after clicking "Refresh All" button, data is delayed.. I have attached a file for reference.. I have circled the data delay message from Refinitiv (data provider) in red.. I have also cross checked with live data online and there is always delay/lag.. My question is - "Is Microsoft planning to solve it?" If yes, by when will it get resolved? if not, I subscribed office-365 for stock data and if I am not getting live data, O-365 is useless for me..

Service ticket number - 1016144833. Stock data is not live.. There is always a delay/lag of 5 to 10 minutes.. Even after clicking "Refresh All" button, data is delayed.. I have attached a file for reference.. I have circled the data delay message from Refinitiv (data provider) in red.. I have also cross checked with live data online and there is always delay/lag.. My question is - "Is Microsoft planning to solve it?" If yes, by when will it get resolved? if not, I subscribed office-365 for stock data and if I am not getting live data, O-365 is useless for me..

Hi,

If when deleting rows with a filter applied included the following to the backround processing maybe it would help reduce wait time. This is based on the fact that deleting a single range of rows when no filter is applied is almost instantaneous:

1. Add 2 temporary columns, one to index (unique ID) each row to keep original sort, the second to give the filtered rows a reference of "2" and the unfiltered rows a reference of "1".




2. Sort the second column and delete down from rows containing "2".




3. Sort by Index column, delete both columns, cursor to A1.

I have to assume the brilliant minds behind the programming of excel have thought of everything but have to manually apply the above to save myself hours a day.

Working example as of 4 minutes ago: (Lenovo Thinkpad i7, latest Version of Excel as of 15/12/20)

Worksheet with Table, 72000 Rows, 84 Columns, 4 formulated Columns.
Deleted 32000 filtered rows where criteria for deletion was randomly distributed throughout spreadsheet: It took 36 minutes to delete.

Best Regards,
Brian

There is No synchronization between the Filter command on the Table Design Tab and the similar command on the Data Tab. So if you apply a Filter from the Data Tab then clear it, the corresponding Filter command on the Table Design is inactive. On the Other hand, if you insert a Slicer from the Table Design Tab ► it inactivates the Filtering commands on the Data Tab. Filter on all tabs should synchronize together as well as with the Slicer.
Looking at the distribution of commands on the Table design Tab, I would prefer removing the Filter command from the Style options group (it has nothing to do with formatting) and rather group it with the Slicer button in the Tools group. to avoid any confusion I would also move the 6 options affecting the styles, to the right side of the Styles gallery. Look at the before and after design.

Currently Office 365 versions of C2R gets all the latest updates and features based on channel but customers which require Office in air gapped environments are stuck point in time releases. Surely its about time to recognise that Office requiring constant internet connectivity isnt possible in every use case and offer updates for those that have invested in the product lifecycle just like Office 365 customers?

Example, Excel's shocking performance has been a pain point for many businesses for many years now with no fixes but as soon as this has finally been sorted out its only available to Office365 and Retail C2R editions. Obviously as this missed the cut off for code release by a matter of a month volume licensed customers now wait three years for the 2022 version? Or release an update so that 2019 at least includes 2019 code instead of mid 2018?