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

sullisnyc44 used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Michael CarrilloInformation Systems Manager
Top Expert 2012

Try running Windows update to ensure that both Windows and Office are fully up to date.  You might have a dll issue with Office.


MS KB article released recently

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial