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?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,653 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Itch Sun-MSFT 2,556 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