Coping formulas within Excel

Hello, I have the attached Excel spreadsheet. The column formulas are limited to line 74.

When I've tried to copy the formatting and formulas down to row 25,000 for some reason the formulas copy, but they stop working after line 74.

Are you ale to help?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun VermaakTechnical SpecialistCommented:
You could convert it to a table and simply add lines to it
jspcAuthor Commented:
Hello, thanks for your reply.

I've opened your file and it is the same as mine in the original post.

I'm not sure you understand my question. After the 74 line, the formulas stop working after you try to copy them down.
Roy CoxGroup Finance ManagerCommented:
using your file I can drag the formulas below row 74 with no problem. However, it's a really bad idea to have numerous rows of unused formulas, especially array formulas in a sheet, because you will find calculation can be slow.  With a proper Table you can use a Calculated Column which expands the formulas as rows are added

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Shaun VermaakTechnical SpecialistCommented:
I've opened your file and it is the same as mine in the original post.
It is not the same, it is a table. Add a new line and you will see the whole line is populated
Roy CoxGroup Finance ManagerCommented:
Pleased to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.