重新计算宏功能单元格 [英] Recalculate macro function cells

问题描述

我一直在使用以下方法在Excel 2010中重新计算我的工作簿，该工作簿是为手动迭代计算而设置的，但它不会导致使用VB宏函数的单元格正确更新。其中一些需要多次迭代，因为值可能
取决于上面单元格的计算值。

Application.CalculateFullRebuild

是否有更好的方法或 一个不同的命令来完成这个目标？

谢谢！

解决方案

你好velvetlady，

这个论坛 主要关注Office客户端相关问题和反馈。由于您的问题与开发涉及Excel的问题更相关，因此我将此线程移至以下专用于Excel的MSDN论坛：

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

感谢您的理解。

最好的问候，

Yuki Sun

I have been using the following to recalculate my workbook in Excel 2010 which is set up for manual iterative calculation but it does not cause cells that use VB macro functions to update properly. Some of these require multiple iterations as values may depend on calculated values from cells above.

Application.CalculateFullRebuild

Is there a better way or  a different command to accomplish this end?

Thanks!

解决方案

Hi velvetlady,

This forum  mainly focus on Office client related question and feedback. Since your issue is more related to developing issues involving Excel, I would move this thread into the following dedicated MSDN forum for Excel:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

Thanks for your understanding.

Best Regards,
Yuki Sun

这篇关于重新计算宏功能单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！