very slow "copy" operation

[vic]

Standard "copy" of a cell, after a "paste", takes about 4-5 seconds.
In a document with 2 sheets with about 117000 cells in total

[SuperTech]

Please share your problematic file so we can investigate further.

If your file is confidential, please send it to forum[at]softmaker.com with a link to this post.

[vic]

I have attached it.
To reproduce: go to the 2nd sheet, "test" and try copy a cell then paste. The "copy" op itself takes very long; while the "paste" op is fast.

Inside the 1nd sheet "large", not the "copy" but the "paste" operation takes very long.

EDIT:

I noticed that grouping (outlining) rows/columns affects the behavior in the "large" sheet: when the groups are collapsed, it's as described above; but when uncollapsed - the "copy" op is very slow, but the "paste" is much faster.

[vic]

I just tested the same file in the most recent, trial version of Microsoft 365's Excel, and there are no such delays there, and regardless of outlining status.

[SuperTech]

We were able to reproduce the issue at our end and have forwarded the details for further investigation.

[SuperTech]

Your file contains a very large number of formulas, which is causing the slowness — this behavior is typical under such circumstances.

To avoid this slowness while working, please go to the ribbon command Formula > Update group > Recalculate dropdown, and uncheck "Recalc automatically".

This will make your sheet faster, but calculations will no longer happen in real time. You can press F9 to recalculate manually whenever needed.

[vic]

But have you noticed this:
"I noticed that grouping (outlining) rows/columns affects the behavior in the "large" sheet: when the groups are collapsed, it's as described above; but when uncollapsed - the "copy" op is very slow, but the "paste" is much faster."
Also, Excel is not slowed by the same file, with auto-re-calculations.