none
Opening and calculating an Excel File takes very long (Size 750 KB around 4000 Rows and 30 Cols) RRS feed

  • Question

  • The Problem: The file was generated with EPPlus but also after changing the file manually with Excel and after a save as it takes again around 2 Minutes to open it. There are quite some calculations in the excel sheet and refreshing them takes around 20 Seconds.

    Is there a posibility to find out why Excel takes so long to open and calculate this file and what it is doing during this time?

    Is there some kind of log I can switch on to trace where excel is spending the time?

    (Other excel files are opening within seconds. Also smaller Files < 300 Rows generated with the same function open very fast...)

    Thursday, June 30, 2016 8:36 AM

All replies

  • Hi Markus,

    This is the forum to discuss questions and feedback for Excel for Developers, I'll move your question to the Technet forum for Excel IT Pro Discussions

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

    Thank you for your understanding.
    Friday, July 1, 2016 2:43 AM