sullisnyc44
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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
MS KB article released recently