Pasting data in excel list

stevenvanderkruk

New Member
Joined
Jul 26, 2007
Messages
4
Hello,

I am having difficulties pasting data into an excel list. I created a list, which contains several formulas in column H till L. The data I want to paste goes into column A till G.
When I start the list only has one record in which the formulas are stored. As far as I know, this is an absolute necessity for keeping them functioning in the list.
When I paste the data into the list everything goes well, however as soon as I try to paste more than 178 records, nothing happens. When only pasting the first 178 there is no problem and all formulas are working aswell.
No the surprising part, when more than 200 lines are present in the list, I can paste in as many lines as I want and there is no problem.

Can someone please help me to solve this problem. Is there a maximum to the number of records which you can paste?

Thanks you so much.

Kind regards,

Steven
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
Hi
We need to know what formula you are using which could hint us at the source of the problem.
Ravi
 

Forum statistics

Threads
1,181,649
Messages
5,931,216
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top