Copy and paste results in #NA

[bird333]

I have been upgraded to Excel 2016 (previously 2010). Sometimes when I copy and paste values I get #NA in the cells instead of the numbers. It also seems to cause the other formulas to change to #NA. I have to recalculate the spreadsheet to get the numbers back and then copy/paste seems to work. What gives? This didn't happen with Excel 2010.

[vba_php]

are you pressing F9 to recalc the spreadsheet? just curious. where are you copying the values FROM? Excel and Access both, I believe, automatically try to detect data types when they are thrown into cells, regardless of where they came from.

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:


Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.