Excel 2003 DSUM 不工作
我的一个客户有一个在 excel 2003 中编写和运行的主要应用程序（我知道，他们也知道，这是一个错误，他们正在等待它正确地合并到他们的 SAP 应用程序中。他们已经等待了很多年）。大多数时候它工作正常，但是本周他们遇到了问题，数据返回#value 条目。
当我研究这个问题时，我发现 DSUM 函数正在返回#value，然后该值被传播到其他地方（我是否提到过 VBA 代码中没有数据验证？）当我查看该函数时，它是使用条件对单独工作表中的一列进行求和，它确定了数据中的许多问题，但即使我修复了这些问题，并且函数分析表明没有错误，它仍然返回#value。
我会发布一些代码，但涉及到 4700 行表，这是相当不切实际的。谁能建议我可以做些什么来取得进展？当源工作表中没有任何错误指示时，为什么 DSUM 返回 #value 问题？我已经搜索了该列，所有值都是有效数字。
抱歉有点含糊，但如果有人能给我关于如何进步的建议，我将不胜感激。 Excel 和 VBA 并不是我真正的专长。
A client of mine has a major application written and running in excel 2003 ( I know, and they know, that it is a mistake, and they are waiting for it to be properly incorporated into their SAP application. They have been waiting for many years. ). Most of the time it works fine, however this week they had a problem, and the data was returning #value entries.
As I looking into this, I identified that a DSUM function was returning #value, which was then being spread across other places ( did I mention that there is no data verification in the VBA code? ) When I looked at the function, which is summing a column in a separate sheet, with a conditional, it identified a number of problems in the data, but even when I fixed them, and the Function analysis indicated no errors, it still returned #value.
I would post some of the code, but there is a 4700 row sheet involved, which is rather inpractical. Can anyone suggest what I might be able to do to progress this? Why is the DSUM returning #value problems, when there is no indication of any errors in the source sheet? I have searched through the column, and all of the values are valid numbers.
Sorry to be a little vague, but if anyone can give me suggestions as to how to progress, it would be appreciated. Excel and VBA are not my real specialities.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我获得 #value 的唯一方法是 3 倍：
您是否还保留有问题的电子表格版本？可能值得确保第一行数据出现错误，特别是看起来像文本但其中包含值的单元格（即，单元格格式可用于显示文本，即使单元格中有值，或者如果第一行也是计算）。
希望这对您有所帮助，并让我们知道您的进展情况。
戴夫
The only way I could get a #value was 3 fold:
Do you still have the offending version of the spreadsheet? Might be worth ensuring the first row of data for errors particularly cells that look like text but have values in them (i.e., cell formatting can be used to display text even if there is a value in the cell, or if the first row is also calculated).
Hope this helps, and do let us know how you get on.
Dave