Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

clipboard error while excel data uploading in sap

Former Member
0 Kudos
11,641

Hi Expert,

We are try to upload excel data through bdc but getting error

"There is a large amount of information on the clipboard . Do you want to be able to paste this information into another program later/

. To save it on the Clipboard so that you can paste it later , click YES
.To delete it from Clipboard and free memory, Click,NO."

After click on NO ,

data not upload and get message msgclass 03.

and again try then again same error getting .

Kindly help me.

Thanks & Regards

Devendra

10 REPLIES 10

0 Kudos
4,974

did you solve this error??? How??

We are facing this issue.

0 Kudos
4,974

try this, worked for us; in excel there is this ribbon on left side called "clipboard". when u expand this section it will give you "options" on bottom of screen on left side.

set this check box for option " collect without showing office clipboard"

close all sap sessions and re-login and check.

if not working try with cntl+alt+del - task manager and end task for all sap sessions.

good luck!

0 Kudos
4,974

Hi Mates,

Do you happen to solve this issue already? I am facing the same issue. For some users, they can upload files properly, but for some, like my PC, are not able to upload it. Do you have any resolutions already?

0 Kudos
4,974
No one has managed to solve this problem. I try this solution but for me does not work:


in excel there is this ribbon on left side called "clipboard". when u
 expand this section it will give you "options" on bottom of screen on 
left side.
set this check box for option " collect without showing office clipboard"


close all sap sessions and re-login and check.

if not working try with cntl+alt+del - task manager and end task for all sap sessions.

Any solution?

0 Kudos
4,974

if it is a domain-based computer the workaround for me was to disable windows firewall, i know it has no correlation, but it worked.

none of the solutions posted related to turn off history on clipboard or options inside excel worked.

MarcoK
Explorer
4,974

You can get rid of this message, if you copy only one cell before closing Excel.

E.g. if you are using FM "ALSM_EXCEL_TO_INTERNAL_TABLE" you can copy it to "Z_ALSM_EXCEL_TO_INTERNAL_TABLE" and insert this code

* Mark only 1 cell
  CALL METHOD OF worksheet 'Cells' = h_cell
      EXPORTING #1 = 1 #2 = 1.
  m_message.
  CALL METHOD OF worksheet 'Cells' = h_cell1
      EXPORTING #1 = 1 #2 = 1.
  m_message.

  CALL METHOD  OF worksheet 'RANGE' = range
                 EXPORTING #1 = h_cell #2 = h_cell1.
  m_message.
  CALL METHOD OF range 'SELECT'.
  m_message.

* copy marked cell into Clippboard
  CALL METHOD OF range 'COPY'.
  m_message.

before

* quit Excel and free ABAP Object - unfortunately, this does not kill
* the Excel process
CALL METHOD OF application 'QUIT'

nishadabdul
Member
0 Kudos
4,974

Hi Folks,

Please try uploading the same file multiple times. It worked for me.

Cheers!

Senthil_S
Discoverer
0 Kudos
4,808

I have the same problem, anybody have a solution?

0 Kudos
4,648

Hello @Senthil_S,

While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as an answer in an old thread. Posting in older threads is not the best way to get guidance.

If you're looking for help, you should start a new discussion instead: https://community.sap.com/t5/application-development-discussions/bd-p/application-developmentforum-b...

Or you can ask a question in our Technology area: https://community.sap.com/t5/technology-q-a/qa-p/technology-questions

Best regards,
Anne

 

Adarsh_Chougale
Newcomer
0 Kudos
2,895

Hi,

I've figured out an alternate solution to disable/avoid clipboard alert, please follow the below-mentioned steps:  

 

ActiveClipboard (ACB): An Office feature that allows for storing of previous copies to paste later different prior copies. This feature is generally only available if Clipboard task pane is displayed to a user. You can disable the feature that causes the most issues by disabling automatic collection.

Disable Auto Collection using the registry:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\General\
(REG_DWORD): AcbControl
VALUE: (enter as hexadecimal) 80000000

Note: Before setting AcbControl, all Office applications (including Outlook etc.) must be closed, no running instances in the task manager. Otherwise, when those apps close, they will write the key back to what it was when those apps launched.

-Adarsh Chougale