Solved

Pasting problems from Access to Excel

Posted on 2011-03-25
1
356 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:pstewartrrm
1 Comment
 
LVL 29

Accepted Solution

by:
leonstryker earned 500 total points
ID: 35217628
Try hitting 'Esc'. If you're cursor in Excel is on the formula bar, Excel will not let you Copy/Paste to the spreadsheet.

Leon
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now