Pasting problems from Access to Excel

Two items. Not sure if they are related.

Generally when I try to paste data from an Acces query into Excel it goes smoothly. However sometimes (I can't detect a pattern) afer I copy the data from Access, the option to paste it into Excel is greyed out and I cannot paste the data.

I also am getting a  "cannot empty clipboard" message in Excel.

I thoughts about what's going on here and how to fix it?
Who is Participating?
leonstrykerConnect With a Mentor Commented:
Try hitting 'Esc'. If you're cursor in Excel is on the formula bar, Excel will not let you Copy/Paste to the spreadsheet.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.