We have a user and the formulas on this one document don't seem to update. It's a simple formula of =cell*cell (ie, =A1*A2)
It simply won't update
we've checked to make sure calculation is set to automatic and it is. we've tried setting it to manual and hitting F9 and it doesn't make a difference
What DOES make a difference is if I click on the cell, highlight the formula at the top of the screen and hit the green check box.
Now, we tried this on another PC, and it updates automatically no problems.
We've tried restarting Excel as well. Both PCs have the same Excel AddIns installed also.
It did it a few weeks ago and CTRL+ALT+F9 worked. Now it does not.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Since your workbook recalculates on other people's computers, the file is probably not corrupted. If the workbook recalculates in Safe mode, then it is likely a problem with the user profile. That's why Rory was asking you to make that experiment.
Before you attempt to completely uninstall Office, I suggest rebuilding your toolbar file to factory specifications. You do this while Excel is not running by renaming your *.xlb toolbar file to *.old. This file, which always exists but may be hidden, is frequently corrupted. If you have tried reinstalling Office or repairing an existing installation, any toolbar corruption problems remain because the installer won't reset the toolbar file.
After renaming the toolbar file, Excel notices during launching that it doesn't have one and creates a new copy to factory specs. Mine (for Excel 2003) is called Excel11.xlb and is located in the XLSTART folder. Your name and location may be different, so please search for it (and there may even be more than one on the computer).
The XLSTART folder is most often located in two places:
C:\Documents and Settings\your Windows log-in name\Application Data\Microsoft\EXCEL\XLSTA
C:\Program Files\Microsoft Office\Office 11\XLSTART This path is for Excel 2003. Earlier versions have a different number after Office
IMPORTANT: The Application Settings folder is hidden by default--so you won't be able to see it unless you choose the option to "Show hidden files and folders" in Windows Explorer's Tools...Folder Options...View menu item
If the preceding doesn't help, you may also want to launch Excel with the RegServer option to reset the registry settings to factory specs. You do this from the Start....Run command line. On my computer, the command looks like "C:\Program files\Microsoft Office\Office11\EXCEL.EXE"
Finally, consider removing any files you find in your XLSTART folder. These may contain macros that are causing the problems.
Adobe Acrobat and Norton Anti-Virus are known to have conflicts with Excel. Usually, upgrading to the latest version of these programs will solve the problem, but please post a comment if your computer has (or had) them installed.
Business Accounts
Answer for Membership
by: pssandhuPosted on 2009-06-01 at 08:19:36ID: 24518360
It could sound a little absurd/stupid but have checked to make sure the formula column type is set number format. Also, if it is number format, sometiems with me the it does not change automatically, so I select the whole column and in first of the first cell a pop shows up, I just select that click on convert to number.
Hope this helps.
P.