Repost: Cut and paste error message problem

Noir · May 4th, 2002, 10:40 PM

I use the following formula to match data between sheet1 and sheet2 of my workbook;
=A2&" Found in row "&MATCH(A2,Sheet2!$A$1:$A$1000,0). The formula works fine but,
when i cut data from a source workbook and paste it into my main workbook, i receive 2 separate error messages 1.Visual Basic Error="File Not Found". 2.MS Excel Error="Cannot Paste Data". Although the data does paste successfully, i get these error messages everytime.

Please advise as to how i can get rid of these error messages.

Thx,
Noir

Nimrod · May 4th, 2002, 10:53 PM

Are you sure that the formula is the same ? Usually when you copy a formula from one workbook to another the formula changes to point back to the source workbook! If this is the case you can modify the new formula so that the workbook name is not included in the formula. Another thing you can try is before you copy the formula append a single quote to the front of formula and then delete the single quote once you've made the copy. IE remove the single quote in the new location. There is probably a way to copy formula's without having to go to all this trouble ... but I have'nt found it yet.

Noir · May 6th, 2002, 06:24 AM

Nimrod,
Thanks for your reply.

What i am actually copying is raw data, not formulas. The data is normally serial numbers, part numbers or descriptions.

Noir

klb · May 6th, 2002, 06:31 AM

I get the same two error messages sometimes when I do a copy paste from Access to Excel. And like you said, the data does paste. It is just annoying.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 4th, 2002, 10:40 PM	#1
Noir Board Regular Join Date: Mar 2002 Posts: 364	I use the following formula to match data between sheet1 and sheet2 of my workbook; =A2&" Found in row "&MATCH(A2,Sheet2!$A$1:$A$1000,0). The formula works fine but, when i cut data from a source workbook and paste it into my main workbook, i receive 2 separate error messages 1.Visual Basic Error="File Not Found". 2.MS Excel Error="Cannot Paste Data". Although the data does paste successfully, i get these error messages everytime. Please advise as to how i can get rid of these error messages. Thx, Noir

May 4th, 2002, 10:53 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Are you sure that the formula is the same ? Usually when you copy a formula from one workbook to another the formula changes to point back to the source workbook! If this is the case you can modify the new formula so that the workbook name is not included in the formula. Another thing you can try is before you copy the formula append a single quote to the front of formula and then delete the single quote once you've made the copy. IE remove the single quote in the new location. There is probably a way to copy formula's without having to go to all this trouble ... but I have'nt found it yet.

May 6th, 2002, 06:24 AM	#3
Noir Board Regular Join Date: Mar 2002 Posts: 364	Nimrod, Thanks for your reply. What i am actually copying is raw data, not formulas. The data is normally serial numbers, part numbers or descriptions. Noir

May 6th, 2002, 06:31 AM	#4
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	I get the same two error messages sometimes when I do a copy paste from Access to Excel. And like you said, the data does paste. It is just annoying.