Link to home
Start Free TrialLog in
Avatar of sullisnyc44
sullisnyc44Flag for United States of America

asked on

excel copy & paste issue with formulas, format painter stops working

Win7/Excel 2010

for some reason the copy & paste function in my excel stops working.

If a cell has a formula and I copy and paste it, it will paste the value but not the formula.

Sometimes the format painter stops working as well.

At first I 'thought' this happened when I open up an older spreadsheet in compatibility mode first before other 2010 spreadsheets first. but i am not able to replicate this behavior.

by the end of the day this functionality will not work for me. has anyone seen this before?
Avatar of Michael Carrillo
Michael Carrillo
Flag of United States of America image

Try running Windows update to ensure that both Windows and Office are fully up to date.  You might have a dll issue with Office.
ASKER CERTIFIED SOLUTION
Avatar of sullisnyc44
sullisnyc44
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sullisnyc44

ASKER

MS KB article released recently