Hello
I'm using this board quite a few times but I never posted a question.
I'm working on a special project in my company and for this project we use excel and vba code.
We got a strange behavior.
With VBA we import data from other workbooks into the main workbook. This tooks about 30s for about 40k rows.
After we inserted two more sheets with a few structured tables and charts/camera objects and other shapes it tooks over 3-9 minutes. The clue is in the macro we didn't touch these sheets at all.
Memory used w/o these two sheets 180Mb
Memeroy used with these two sheets 230Mb
CPU usage mostly the same.
without these two sheets => 30s
with the sheets, delete all charts/camera objects/shapes => 45s
with sheets and objects => 3min up to 9min
in the last case the time for each time we call the macro it's increased by 3min and finds it's peak at about 9 min
usage of memory and cpu are more or less the same.
during the macro following things are disabled
- Screenupdating = false
- Calculation = manual
- enableEvents = false
Thank you for your help
Ashi
I'm using this board quite a few times but I never posted a question.
I'm working on a special project in my company and for this project we use excel and vba code.
We got a strange behavior.
With VBA we import data from other workbooks into the main workbook. This tooks about 30s for about 40k rows.
After we inserted two more sheets with a few structured tables and charts/camera objects and other shapes it tooks over 3-9 minutes. The clue is in the macro we didn't touch these sheets at all.
Memory used w/o these two sheets 180Mb
Memeroy used with these two sheets 230Mb
CPU usage mostly the same.
without these two sheets => 30s
with the sheets, delete all charts/camera objects/shapes => 45s
with sheets and objects => 3min up to 9min
in the last case the time for each time we call the macro it's increased by 3min and finds it's peak at about 9 min
usage of memory and cpu are more or less the same.
during the macro following things are disabled
- Screenupdating = false
- Calculation = manual
- enableEvents = false
Thank you for your help
Ashi