ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can't paste in excel without having an open excel sheet! (https://www.excelbanter.com/excel-discussion-misc-queries/116462-cant-paste-excel-without-having-open-excel-sheet.html)

troy stud

can't paste in excel without having an open excel sheet!
 
Can't paste in excel when opening a brand new excel worksheet. I am copying
files from a Microsoft Access 2003 database and then opening up a brand new
2003 excel sheet. When I copy from access and then go open a blank excel
sheet to paste, the paste feature is grayed out. When I go back to the access
sheet and recopy then go back to the already open excel sheet, I can then
paste. I'm able to paste in excel only after excel has been already opened as
long as I go back to the Access sheet and copy again. It doesn't seem to want
to paste from access into excel when opening a brand new excel sheet to paste
to, only if it has been already opened and left open.

Dave Peterson

can't paste in excel without having an open excel sheet!
 
So why not just open excel before you do the copy????

troy stud wrote:

Can't paste in excel when opening a brand new excel worksheet. I am copying
files from a Microsoft Access 2003 database and then opening up a brand new
2003 excel sheet. When I copy from access and then go open a blank excel
sheet to paste, the paste feature is grayed out. When I go back to the access
sheet and recopy then go back to the already open excel sheet, I can then
paste. I'm able to paste in excel only after excel has been already opened as
long as I go back to the Access sheet and copy again. It doesn't seem to want
to paste from access into excel when opening a brand new excel sheet to paste
to, only if it has been already opened and left open.


--

Dave Peterson

troy stud

can't paste in excel without having an open excel sheet!
 
Because for this particular user it's a little bit of a hassle to costantly
going back and forth 2 times when she can do it just the one time copy and
then open up another office product and paste. Since she has multiple files
she has to copy and paste. It has something to do with an empty clipboard
every time you try to open another office prodicu...word, excel...

"Dave Peterson" wrote:

So why not just open excel before you do the copy????

troy stud wrote:

Can't paste in excel when opening a brand new excel worksheet. I am copying
files from a Microsoft Access 2003 database and then opening up a brand new
2003 excel sheet. When I copy from access and then go open a blank excel
sheet to paste, the paste feature is grayed out. When I go back to the access
sheet and recopy then go back to the already open excel sheet, I can then
paste. I'm able to paste in excel only after excel has been already opened as
long as I go back to the Access sheet and copy again. It doesn't seem to want
to paste from access into excel when opening a brand new excel sheet to paste
to, only if it has been already opened and left open.


--

Dave Peterson


Dave Peterson

can't paste in excel without having an open excel sheet!
 
It's not a problem for just that particular user. It sounds like a time for her
to change her order of doing things. (I've tried to change the order for me.
When I forget, I have to copy once again.)

troy stud wrote:

Because for this particular user it's a little bit of a hassle to costantly
going back and forth 2 times when she can do it just the one time copy and
then open up another office product and paste. Since she has multiple files
she has to copy and paste. It has something to do with an empty clipboard
every time you try to open another office prodicu...word, excel...

"Dave Peterson" wrote:

So why not just open excel before you do the copy????

troy stud wrote:

Can't paste in excel when opening a brand new excel worksheet. I am copying
files from a Microsoft Access 2003 database and then opening up a brand new
2003 excel sheet. When I copy from access and then go open a blank excel
sheet to paste, the paste feature is grayed out. When I go back to the access
sheet and recopy then go back to the already open excel sheet, I can then
paste. I'm able to paste in excel only after excel has been already opened as
long as I go back to the Access sheet and copy again. It doesn't seem to want
to paste from access into excel when opening a brand new excel sheet to paste
to, only if it has been already opened and left open.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com