clipboard error while excel data uploading in sap

[Former Member]

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

[former_member148441]

did you solve this error??? How??

We are facing this issue.

[Former Member]

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!

[former_member537662]

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?

[ivn_redondorodrguez]

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?

[former_member1132262]

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]

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]

Hi Folks,

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

Cheers!

[Senthil_S]

I have the same problem, anybody have a solution?

[anne-petteroe]

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