Microsoft Excel cannot paste the data

Asked By 60 points N/A Posted on -
qa-featured

I have 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?

SHARE
Best Answer by Sharath Reddy
Answered By 0 points N/A #83034

Microsoft Excel cannot paste the data

qa-featured

I hope this 3 probable solution may help you with your problem:

1. Are the data you are trying to paste have merged cells? This can be your problem since data from merged cells CANNOT be pasted into a non-merge cell range. If the merged range is involved, it must have the same ranges.

2. You must check the macro itself if you haven't done it yet. Your data might be set to function only within certain cells.

3. Sometimes, updating you Office can be a good fix.

You can follow these steps to fix your problem:

  1. First, you select the cell you want to copy.
  2. Second, you HOLD down OPTION then drag the cell to the new location. (Excel creates a copy of the cell in that location).
  3. Third, you Hold down CONTROL, click the new cell, and then click Hyperlink on the shortcut menu. 
  4. Fourth, click the document tab in the Insert Hyperlink dialog box.
  5. Fifth, click LOCATE under ANCHOR.
  6. Lastly, type the cell reference that you used in step 1 in the TYPE IN CELL REFERENCE box. Then click OK.

I really hope this would help. Please post back with more details about what you have and what you want to do. I will be willing to give solutions to your problems. Thank you very much.

Answered By 0 points N/A #83035

Microsoft Excel cannot paste the data

qa-featured

You have no error on your MS Excel. It does its job as long as there is no condition on your Macro that prevents it from continuing the action when a specific error handler is set.

It can either be two things. It either your VBA code is wrong or the database file where you upload your information accidentally went to another folder or have been deleted.

I suggest that you look at your code once more and then locate your database file. Look at your code carefully, you might have edited your code accidentally. It should be on the directory path, look to it carefully that corresponds to where your database is and its correct filename.

Locate your database, use search as much as possible to all of your directories. It might be missing or moved to another folder accidentally. Look in your recycle bin as well it might be there. That is why it is a must to create a backup of the database always.

Answered By 10 points N/A #83036

Microsoft Excel cannot paste the data

qa-featured

Hi Russell,

I suspect there should be something wrong with the Visual Basic Application (code) that you have used in the certain macro that you are using for the excel worksheet. Either you copied that wrong code, or you are using a macro that does not offer the functionality you want to it to offer.

Alternatively, you could have copied the right code but in the process of editing it to suit your situation you ended up leaving some bugs that are responsible for the errors that you are receiving. So I will advice that you crosscheck the code, make changes wherever they are needed, and see if your spreadsheet works fine.

Hope this helps.

Regards,

Lee Hung.

Answered By 0 points N/A #83038

Microsoft Excel cannot paste the data

qa-featured

Most probably your VBA code is the reason behind these alerts. What you should do now is performing a debug operation.

To do so, press ALT + F8 to open up the Macro dialog box. Here, find and select the macro involved and click Edit on the right.
A Visual Basic Editor will open up and show the code that makes the macro work.
 
Now open your Microsoft Excel document in a separate window and tile it horizontally or vertically. Now maximize the Visual Basic Editor window and point your cursor in the host document where you want the macro to start.
 
Press F8 to step through each line of the macro. Now in the document if you see the problem occurring again,
 
You will be able to fix it in the code.

 

Answered By 0 points N/A #83040

Microsoft Excel cannot paste the data

qa-featured

Hi Russell Aderson,

Try the following Solutions:

  1. Remove the Excel Security Update.
Excel security Update
After uninstalling it, you have to reboot and it will now permit you to copy and paste your file into the Excel.
To prevent from automatically applying the patch you have to turn the automatic Updates OFF.

2. You can also try these steps without uninstalling the Security Updates:

  • You have to close the Excel first.
  • Have a copy of your data on a clipboard and Exit Excel.
  • If a message like this appear. There is a large amount of data in the clipboard. Do you want to paste it to another program? Just Click YES and you can paste it to a different program.
  • Now paste your clipboard data without exiting the EXCEL, Open first the information from Office Clipboard.
Clipboard

Then have the data paste it from the Office Clipboard.

Clipboard Data

Hope this might help you.

Thanks, 

Fernando Magallanes

Answered By 0 points N/A #83041

Microsoft Excel cannot paste the data

qa-featured

Hello Russel,

Here is a solution to solve your issue regarding excel. First, go to start and then in the search box enter excel.exe/s and click okay. It is in the safe mode if excel starts without any problem. Take a look at the excel start directory and if the files are there when excel get started, files will be loaded there.

You also need to look at the tools and uncheck and add-ons. Now you can open excel and try what you are doing again. This is a very simple solution which is working for me when I encountered that kind of error in MS Excel.

Zorian

Best Answer
Best Answer
Answered By 567105 points N/A #83042

Microsoft Excel cannot paste the data

qa-featured

I think those alert messages that appeared were only to inform you that you are copying or pasting cells that have macros and are somewhat linked to other cells within your worksheet. If you are not really sure if there is a problem on your computer, try running a disk check to see if there is an error in your hard drive’s file structures that might cause this. If you have your own disk utility application installed on your computer, run and check your hard drive. Else, use the Windows disk check.

  1. Right click on drive C and then select Properties.
  2. Click Tools tab.
  3. Click Check Now.
  4. Check Automatically fix file system errors and then hit Start.

You may also uninstall Microsoft Excel and then install it back to restore its settings back to default.

Answered By 0 points N/A #83043

Microsoft Excel cannot paste the data

qa-featured

Hi,

I think you have tried to copy and paste in a merged cell range. You cannot paste data from merging a cell range of non merge cell range. You can try this solution:-

Select the cell and click to merge and center for toggle it to off. After that you can try again to copy and paste data.

If problem persists then clean computers boot state and restart your computer.

Clean computers boot state is a long process and need to perform carefully.

Answered By 40 points N/A #83044

Microsoft Excel cannot paste the data

qa-featured

Hi Russell Anderson 

There is another Techyv post which is addressed your problem too. Check out this page and get more idea to solve this issue.

Cannot cut and paste in Excel

Login/Register to Answer

Related Questions