Pasting data in excel list

[stevenvanderkruk]

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

 

[ravishankar]

Hi
We need to know what formula you are using which could hint us at the source of the problem.
Ravi