Cannot cut and paste in Excel

Asked By Julie Bailey 10 points N/A Posted on - 07/23/2011

 

 I created a worksheet which is used to upload information into a database that has various validations and database insert macros running in the background.

But when I attempt to Cut and Paste rows into my worksheet, I get an alert message box with the title "Microsoft Visual Basic" and then the message 'File not found'.

When I hit the “OK” button in the window another alert message box is opened saying "Microsoft Excel cannot paste the data". However when I close this message box the data is pasted into the worksheet. 

Could it be that there is something wrong with my VBA code?

• Status: Open
• Question Views: 2368
• Answer Count: 5
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by JayPB

Go To Solution

Best Answer

Best Answer

Answered By JayPB 0 points N/A #83082

Cannot cut and paste in Excel

Hey,

This error is obvious due to occasional misbehavior of rdclip.exe avoiding the use of copy function in MS Excel. This matter can be temporarily resolved by killing this process.

You can do that from Windows Task Manager :

• Process tab or Start -> Run ->type ‘taskkill/F/IM rdclip.exe and click ok.

You can also try opening MS Excel in Safe Mode and check if the copy function is working:

The following command will open MS Excel without Add-ins or hidden workbooks.

• Navigate to Start -> Run and type "C:Program FilesMicrosoft OfficeOfficeExcel.exe /Safe” or “Excel.exe/safe”.
• After that go to Tools -> Addins ->uncheck all addins and exit Excel.

Otherwise the problem will be with the XLSTART directory and you need to clean that directory.

About JayPB

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/23/2011
• Question Category: MS Excel

Answered By CM Punk 0 points N/A #83084

Cannot cut and paste in Excel

 

It seems to me that your rdpclip.exe is malfunctioning, resulting the prevention of using Copy function in Windows or Office. A temporary fix for this is to the process of rdpclip.exe.

 

So go to Run from Start menu and type – – taskkill /F /IM rdpclip.exe

 

About CM Punk

Questions
0

Answers
17

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/23/2011
• Question Category: MS Excel

Answered By jewel uddin 0 points N/A #83085

Cannot cut and paste in Excel

Here all solution I like it.

About jewel uddin

Questions
0

Answers
31

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/30/2011
• Question Category: MS Excel

Answered By ELM_Steve 0 points N/A #83087

Cannot cut and paste in Excel

Hi,

Yes, this seems a potential issue with your VBA code. Actually the VBA code is like a remote control of Excel. The best solution is to use MACRO instead of VBA code. If you are not familiar with MACROs then I will suggest that please turn off your Excel Alert window as you are achieving your desired results.

You can use the following command:

Application.DisplayAlerts = Flase

Please let me know if this works for you otherwise please send me your VBA code and I will go through with your code and will suggest some other best and possible solutions. Thanks.

Regards,

ELM_Steve

About ELM_Steve

Questions
0

Answers
27

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/22/2012
• Question Category: MS Excel

Answered By Malcolm H Jones 50 points N/A #83088

Cannot cut and paste in Excel

Hi Julie Bailey 

Side by side these solutions also check out this Techyv post too "Microsoft Excel cannot paste the data" to get more idea to fix this issue. 

About Malcolm H Jones

Questions
16

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/31/2014
• Question Category: MS Excel