Excel(2010)中是否存在最大数量的公式字段 [英] Is there a maximum number of formula fields allowed in Excel (2010)

问题描述

我正在使用一个csv文件为SQL Server构建一些插入语句，并试图在插入数据之前清除我的数据，并正在使用公式对其进行查找.我有大约64000行和大约30列要清理.

Im using a csv file to build some insert statements for SQL server and am trying to clean my data before it gets inserted, and am using formulas to fo it. I have around 64000 rows and about 30 columns to clean.

我已经完成了大部分工作，但是现在，用于确保电话号码正确的公式刚刚开始失效，现在只是将论坛的文本而不是清理后的电话号码放到了单元格中.同一论坛正在其他单元中工作.

Ive got most of the way through it, but now a formula to make sure telephone numbers are correct has just started to fail, and now just puts the text of the forumla into the cell, rather than the cleaned telephone number. The same forumla is working in other cells.

在工作簿或工作表中可以使用的公式数量是否有限制?

Is there a limit to the number of formula you can have in a workbook or worksheet?

我正在使用Excel 2010

I am using Excel 2010

推荐答案

请参见

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.

例如:独特的单元格格式/单元格样式64,000

For example: Unique cell formats/cell styles 64,000

这篇关于Excel(2010)中是否存在最大数量的公式字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！