Automatic Updating of cells with formulas...

  • Thread starter Thread starter Edge118
  • Start date Start date
E

Edge118

Hi, I have a spread sheet with several rows that use formulas t
generate their contents, but the problem is that everytime I alter th
data in my table, it has to recalculate all the derived cells and i
takes like 10 seconds every time I change something in my data. Is i
possible to disable automatic updating of cells, so that I can ente
all of my new data and then enable it again so it can updat
everything? Thanks for your help.

R
 
Hi

tools / options/ calculations tab - set to manual

Cheers
JulieD
 
Good answer from JulieD.

Once set that way, use F9 to manually recalc. I would
SUGGEST that if you follow JulieD's advice that you add a
note to your sheet to remind yourself (and perhaps users)
that you've set manual recalc and to use the F9 key to
update; otherwise you might forget and leave an updated
sheet unrecalculated.
HTH2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Why doesn't excel count function update automatically? 1
Create a formula with a moving cell 1
Excel Formula to update itself automatically. 10
My cell formula results won't update automatically. Help? 1
Attempted edit of protected cell jumps user to another cell 2
VLOOKUP refuses to automatically update 1
Automatically update excel worksheet formula 7

Back
Top