formulas

A

Anthony

suddenly, when values in a formula are changed, the linked totals or formulas
in another column do not update - Never experienced this problem before. Any
suggestions?
 
S

Sandy Mann

Check that Calculation is set to Automatic:

Tools > Options > Calculation.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Autonumber field in Excel that behaves the same as Access 0
Consolidation Table from Different Excel Tabs with Different Format 1
Copy addition formula of non-consecutive horizontal cells 2
Getting a formula to reflect added columns 10
Excel Formula Issue 2
Notes not showing up in Powerpoint Presenter Mode 0
New Bug in Track Changes in Word 365 0
Use TODAY() function as the criteria in a SUMIF formula 1

Top