That's not really my problem because the problem is present when I am alone on the server.
It's like multi thread is disabled even if the option is enabled.
m
Matthias Schlimm
01/23/2022, 3:07 AM
Which Office Version, like O365 monthly enterprise channel or other, server OS, Client like windows, Linux, MacOS. Additional environment information please.
o
Osiris Amanpour
01/23/2022, 6:22 PM
You can also try to open Excel with the command line switch /safe, then open your document from Excel.
See if you get the same results while editing the file.
s
Scott Knights
01/23/2022, 11:18 PM
Try turning off auto recalculation if the sheet has a lot of data imports or formula. Enter the data then hit F9 to do calculation once instead of every time you enter data into a cell. Also check that formatting hasn't been applied too liberally. Had a case recently where the user had formatted every single cell on multiple worksheets in a workbook. Excel was having to store information about 17,179,869,184 cells on every sheet. It was a bit resource hungry.
j
Julien Destombes
01/24/2022, 4:51 PM
I found my problem !
It was automatically flash fill option ! This option is present in advanced option of Excel. The problem is only present on On Premise version (reproduce on 2013 through 2019).
Now without the option everything works great (option can be disabled by GPO)
Thanks for your time to help me.