View original (French)

Speeding up calculations in an Excel file

massimo888 Posted messages 209 Status Member -  
massimo888 Posted messages 209 Status Member -
Hello,

I am in the process of creating a file with a lot of rows (40,000), and it takes a lot of time to perform the calculations...
The function used is: VLOOKUP

I would like to know if you have a solution to speed up the calculation in this file, please.

My actions:
- I have disabled automatic calculation.

Thank you.

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    Since your spreadsheet is not static and uses 40,000 formulas, it requires a significant amount of calculation time.
    - reconsider the use of formulas and the arrangement of data
    - switch to manual as you did
    - use a PC with an SSD, plenty of memory, and an ultra-performance processor.
    - have a coffee while it's calculating ;-) ;-)
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    3
    1. massimo888 Posted messages 209 Status Member
       
      Hello,

      Thank you very much for your response.

      I’m leaving the question open just in case anyone has an idea... ;)

      Best regards.
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      How do you want us to know if it can be improved without seeing an excerpt of your file?
      Eric
      0