Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel 2003 Clipboard Question

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Excel 2003 Clipboard Question

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel 2003 Clipboard Question

Hi Luke,
Thanks for your reply. I tried that and I am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Is there anything
else I can do?
Thanks!

"Luke M" wrote:

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel 2003 Clipboard Question

I tried your suggestion and am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Anything
else I can do?
Thanks!


"CommMajor" wrote:

Hi Luke,
Thanks for your reply. I tried that and I am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Is there anything
else I can do?
Thanks!

"Luke M" wrote:

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Excel 2003 Clipboard Question

Is the copy/pasting being done through a macro?

If that were the case enter this line after the paste

Application.CutCopyMode = False

If not through macro I have no ideas for you. No matter what settings I
use, when I answer "No" to the query the clipboard is cleared.

After you click "No" what next step are you making that brings the message
up again?

Closing the workbook?


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 06:49:02 -0800, CommMajor
wrote:

I tried your suggestion and am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Anything
else I can do?
Thanks!


"CommMajor" wrote:

Hi Luke,
Thanks for your reply. I tried that and I am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Is there anything
else I can do?
Thanks!

"Luke M" wrote:

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel 2003 Clipboard Question

Nope, no macro. I am copying and pasting multiple workbooks, so the same
steps are repeated over and over. Open old spread sheet, open new spread
sheet. Copy material from old spread sheet, paste in new spread sheet. Close
old spread sheet, get message every time. What do you think? Thanks!

"Gord Dibben" wrote:

Is the copy/pasting being done through a macro?

If that were the case enter this line after the paste

Application.CutCopyMode = False

If not through macro I have no ideas for you. No matter what settings I
use, when I answer "No" to the query the clipboard is cleared.

After you click "No" what next step are you making that brings the message
up again?

Closing the workbook?


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 06:49:02 -0800, CommMajor
wrote:

I tried your suggestion and am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Anything
else I can do?
Thanks!


"CommMajor" wrote:

Hi Luke,
Thanks for your reply. I tried that and I am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Is there anything
else I can do?
Thanks!

"Luke M" wrote:

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!


.

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Excel 2003 Clipboard Question

After you paste do you hit Enter or Esc to clear the marching ants from old
spread sheet before closing?


Gord

On Wed, 11 Nov 2009 09:40:02 -0800, CommMajor
wrote:

Nope, no macro. I am copying and pasting multiple workbooks, so the same
steps are repeated over and over. Open old spread sheet, open new spread
sheet. Copy material from old spread sheet, paste in new spread sheet. Close
old spread sheet, get message every time. What do you think? Thanks!

"Gord Dibben" wrote:

Is the copy/pasting being done through a macro?

If that were the case enter this line after the paste

Application.CutCopyMode = False

If not through macro I have no ideas for you. No matter what settings I
use, when I answer "No" to the query the clipboard is cleared.

After you click "No" what next step are you making that brings the message
up again?

Closing the workbook?


Gord Dibben MS Excel MVP

On Wed, 11 Nov 2009 06:49:02 -0800, CommMajor
wrote:

I tried your suggestion and am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Anything
else I can do?
Thanks!


"CommMajor" wrote:

Hi Luke,
Thanks for your reply. I tried that and I am still getting the message
"There is a large amount of information on the Clipboard. Do you want to be
able to paste this information into another program later?" Is there anything
else I can do?
Thanks!

"Luke M" wrote:

From the clipboard (Edit - clipboard) go to options, and uncheck the first 3
options (including "collect w/o showing clipboard"). If you're not using the
clipboard, no reason to store things to it, correct?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CommMajor" wrote:

Hello,
When I am trying to copy and paste I receive this message "There is a large
amount of information on the Clipboard. Do you want to be able to paste this
information into another program later?" I click 'No' every time. I've tried
clearing the clipboard in Excel and Word and I still get this message. How do
I stop this message from coming up again? Thanks!


.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Clipboard CommMajor Excel Discussion (Misc queries) 0 November 4th 09 04:51 PM
Clipboard Shrinkage: Excel 2003 to 2007 JP Excel Discussion (Misc queries) 0 June 16th 08 08:09 PM
How to permantently hide clipboard pane on the right side of Word/Excel 2003? Goran Ivanic Excel Discussion (Misc queries) 1 May 7th 08 10:37 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"