Very slow Excel file
Solved
Kyuubi_NC
Posted messages
46
Status
Membre
-
timtim -
timtim -
Hello,
I'm currently working on a database in an Excel file. I had some updates to make, and when I added some client names, the file suddenly became very, very slow even though it showed no signs of slowness before. However, this file isn't very large as it barely exceeds 1 MB on my disk.
If anyone has the slightest idea of what could have caused such a slowdown in the file (because it comes from the file and not the machine), I would appreciate any ideas :)
Thank you all,
Configuration: Windows 7 / Chrome
I'm currently working on a database in an Excel file. I had some updates to make, and when I added some client names, the file suddenly became very, very slow even though it showed no signs of slowness before. However, this file isn't very large as it barely exceeds 1 MB on my disk.
If anyone has the slightest idea of what could have caused such a slowdown in the file (because it comes from the file and not the machine), I would appreciate any ideas :)
Thank you all,
Configuration: Windows 7 / Chrome
2 réponses
Hello,
I had the same issue due to numerous copy-pasting and formatting reproductions. The source cells had conditional formatting. After copying, I ended up with over a thousand instructions on overlapping ranges, and there was just one thing to do....
If you have too many heavy formulas, also consider disabling automatic calculation:
I had the same issue due to numerous copy-pasting and formatting reproductions. The source cells had conditional formatting. After copying, I ended up with over a thousand instructions on overlapping ranges, and there was just one thing to do....
- Conditional formatting -> Clear conditional formatting
If you have too many heavy formulas, also consider disabling automatic calculation:
- file -> options -> advanced options -> Formulas: on order
