We help IT Professionals succeed at work.

Formula Cell Not Refreshing in Excel 2010

sborchers
sborchers asked
on
528 Views
Last Modified: 2013-12-27
Excel 2010 we have a cell where we enter a dollar amount, which then changes 3 other cells based on the formula for each cell.  When this happens the new numbers get calculated and display in each cell, but the original amount that was entered into those cells, stays also.  So the numbers in those 3 cells can not be easily read.  If you minimize excel and then open it again, or click on a new worksheet and then go back to the worksheet the numbers will display correctly, without the original numbers in background.  We have installed SP2 and all office updates that have currently been released.  Has anyone seen this before?Excel Example
Comment
Watch Question

Top Expert 2008

Commented:
I think it has more to do with your graphics driver than with office per se. Have you tried updating or reinstalling those?

Thomas

Author

Commented:
It does it on several different workstations.  We've tried at least 4 different pc's, all of which are different models but running Office 2010.  Thanks, Mike
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
Can you clean up the unwanted data from the file and upload it here to demonstrate your problem?
CERTIFIED EXPERT

Commented:
Check Options, Advanced and disable/enable 'hardware graphics acceleration' to see if that makes a difference.

You mentioned multiple workstations is it just this one workbook or more than one?

Reg

Author

Commented:
I'll have check with the user tomorrow, if it happens for other workbooks.  Thanks for the input, I'll update tomorrow.  Thanks, Mike
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Found a possible solution on our own.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.