topic Re: clipboard error while excel data uploading in sap in Application Development and Automation Discussions

clipboard error while excel data uploading in sap

Former Member — Wed, 15 Jul 2015 05:37:17 GMT

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

Re: clipboard error while excel data uploading in sap

former_member148441 — Wed, 25 Nov 2015 21:51:42 GMT

did you solve this error??? How??

We are facing this issue.

Re: clipboard error while excel data uploading in sap

Former Member — Fri, 08 Apr 2016 17:51:00 GMT

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!

Re: clipboard error while excel data uploading in sap

former_member537662 — Tue, 28 Jun 2016 00:56:38 GMT

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?

Re: clipboard error while excel data uploading in sap

ivn_redondorodrguez — Wed, 12 Feb 2020 11:11:01 GMT

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?

Re: clipboard error while excel data uploading in sap

former_member1132262 — Fri, 07 Jan 2022 20:55:45 GMT

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.

Re: clipboard error while excel data uploading in sap

MarcoK — Fri, 25 Feb 2022 11:57:08 GMT

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'

Re: clipboard error while excel data uploading in sap

nishadabdul — Tue, 07 Nov 2023 05:10:49 GMT

Hi Folks,

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

Cheers!

Re: clipboard error while excel data uploading in sap

Senthil_S — Wed, 31 Jan 2024 12:24:53 GMT

I have the same problem, anybody have a solution?

Re: clipboard error while excel data uploading in sap

AnnePetteroe — Mon, 05 Feb 2024 13:47:00 GMT

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-board

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

Re: clipboard error while excel data uploading in sap

Adarsh_Chougale — Thu, 09 May 2024 05:36:21 GMT

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