Excel freezing after each cell update

Jjjjjjjjbarry

Hi,

Can anyone help with this?

I have sheet that suddenly started freezing for about 7-10 seconds every time I add/change a value in a cell. Once I add the value and then hit enter or click into a different cell it freezes. This started happening recently and I don't know why.

I've now just discovered a work around. If I put an "=" before the value it doesn't freeze and I quickly move on without waiting for up to 10 seconds.

It's a complicated enough sheet with lots of pivots and lookups so I thought I'd never solve it but the fact that it works perfectly by adding the = before a value means it's not the complexity of the sheet that's causing it?

Obviously, I'd like to solve further and not have to add the = as I used this so much, even that is a nuisance

Any help much appreciated - thanks!

TrueDub

Try switching off Automatic Recalculation and see if that changes things.

namenotavailablE

Anotehr possibility- if your sheet has some VBA code attached, changing a cell triggers the various 'events' attached to the sheet e.g. Sheet Change, Sheet _Calculate etc.

You can add 'Application.Enableevents=false' (without the inverted commas') before the VBA code runs. Remember to also add 'Application.Enableevents=true' at the end of the code

Jjjjjjjjbarry

TrueDub wrote: »

Try switching off Automatic Recalculation and see if that changes things.

Unfortunately this doesn't make a difference. It's really odd to me putting in an = makes a difference. Also copying and pasting values works fine.

Jjjjjjjjbarry

namenotavailabl wrote: »

Anotehr possibility- if your sheet has some VBA code attached, changing a cell triggers the various 'events' attached to the sheet e.g. Sheet Change, Sheet _Calculate etc.

You can add 'Application.Enableevents=false' (without the inverted commas') before the VBA code runs. Remember to also add 'Application.Enableevents=true' at the end of the code

I'm not that advanced unfortunately so don't think it's VBA. Thanks for the suggestion though!

ct5amr2ig1nfhp

What version of Excel are you using? Is it an xls or xlsx? And how large is the file?
Windows 10? Do you have any pending OS or Office updates?

Jjjjjjjjbarry

It's 2013 and the file is .xlsx
size 19000 KB but always been fairly big.
Windows 10

Work laptop so don't usually notice any updates, think they must happen in the background. I'll check.

Esel

What format are the cells into which you are entering data?

Entering = at the start denotes a formula, AFAIR.

Jjjjjjjjbarry

They are a number format.

ct5amr2ig1nfhp

I presume you have tried the same Excel file on another device (PC/laptop)? Are you seeing the same issue with the file on another device?

Jjjjjjjjbarry

Oddly enough, I've tried it from someone else's machine and it worked fine without this lag. So must be some setting in my excel that's changed as opposed to the sheet setup.

namenotavailablE

Try this:

File | Options | Advanced and then check the settings as per the following diagram:

ct5amr2ig1nfhp

Do a repair on office if the above doesn't work. See if that resets Excel to whatever way you had your settings.

Jjjjjjjjbarry

Yeah the above settings were already like that so must try a repair job and see if that works. Thanks for the help. Good idea checking from another computer. Hadn't thought of that, as dumb as it makes me sound!

ct5amr2ig1nfhp

Did you get sorted?

Jjjjjjjjbarry

Haven't had a chance to risk it yet. Afraid it will brick my excel! hope to give it a go in next week when I have more IT support on hand!