Avatar of sborchers
sborchers asked on

Formula Cell Not Refreshing in Excel 2010

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
Microsoft Excel

Avatar of undefined
Last Comment
sborchers

8/22/2022 - Mon
nutsch

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

Thomas
ASKER
sborchers

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 Husain

Can you clean up the unwanted data from the file and upload it here to demonstrate your problem?
Your help has saved me hundreds of hours of internet surfing.
fblack61
regmigrant

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
ASKER
sborchers

I'll have check with the user tomorrow, if it happens for other workbooks.  Thanks for the input, I'll update tomorrow.  Thanks, Mike
ASKER CERTIFIED SOLUTION
sborchers

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
sborchers

Found a possible solution on our own.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.