Is there a maximum number of formula fields allowed in Excel 2010

Question

I'm utilizing a CSV file to create some insert statements for SQL Server, and I'm using formulae to try and clean up my data before it gets inserted. I need to clean roughly 30 columns and 64,000 rows.

I've gotten most of the way through it, but a formula that checks that phone numbers are correct has recently started to fail and is no longer inserting the cleaned phone number into the cell, but rather just the formula's text. Other cells are using the same formula.

Is there a maximum amount of formulas that can be included in a workbook or worksheet?

Answer 1

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate a set formula limit but you may be hitting one of the other ones.