Problem with automatic update of formulas in Excel 2003
Thread poster: Fan Gao

Fan Gao
Australia
Local time: 12:22
Member (2006)
English to Chinese
+ ...
Feb 6, 2007

Hi,
I wonder if anyone has come across this problem before. I have a spreadsheet set up in Excel 2003 and the spreadsheet consists of several pages or sheets. I set up formulas on each page which take information from other pages so when one formula or calculation is changed, then the corresponding cells on other pages will automatically recalculate.

For example, inputting the latest exchange rate for USD-GBP on the "rates" page will automatically update cells on other pages that use that rate within their formula.

This spreadsheet has been working fine for months and everytime I would make updates, everything else would automatically update with the new information. Now I find this is not happening anymore.

Now whenever I change one thing on one page, I then have to go through the other pages individually, click on the cell that should have updated, click within the formula itself at the top of the page, press enter and then it updates.

I have made no changes to my system whatsoever so I can't think why this has suddenly stopped working.

I hope this all makes sense. Can anyone advise?

Many thanks,
Mark


Direct link Reply with quote
 
Charlie Bavington  Identity Verified
Local time: 02:22
French to English
Check settings?? Feb 6, 2007

You haven't said if you've checked this:

Under Tools, options, calculation tab - is the "automatic" button selected?

Sometimes, I do find that these things seem to change themselves - whether Word displays images or not seems to vary with the weather on my laptop


Direct link Reply with quote
 

Fan Gao
Australia
Local time: 12:22
Member (2006)
English to Chinese
+ ...
TOPIC STARTER
Thank you Feb 6, 2007

Well this is embarrassing! The first thing I always tell people when they have problems is to check their settings/options. I could have sworn I'd already checked but obviously not.

You're quite right of course. For some reason only known to Excel, it had changed to manual.

Thanks for taking the time to reply Charlie, much appreciated.

Best wishes,
Mark


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Problem with automatic update of formulas in Excel 2003

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search