Share via

Is the Data Table Function broken in Excel 2007 (Build 13029.20344)?

Sam Savage 1 Reputation point
2020-08-21T06:28:52.703+00:00

I and my sponsor corporations make heavy use of the Excel Data Table. In 2007 (Build 13029.20344), the calculation time appears to have become roughly 100 times slower. This will disable many applications, and I will need to send out an urgent warning to my sponsors not to upgrade to this build. Does anyone have information on this?

Microsoft 365 and Office Excel For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Itch Sun-MSFT 2,566 Reputation points
    2020-08-21T08:08:24.7+00:00

    According to your description, it is not broken, it is just low performance and running slowly.

    Unfortunately, there is not much similar feedback, and it is certain that low performance due to the use of large numbers of data tables in Excel is inevitable.

    I recommend that you do not use too many formulas in a large number of data tables, especially loop or iterative formula references.

    In addition, if circumstances permit, you can also try a higher version of excel.

    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.