Hello,
Im facing an issue with excel file when working with 100+ sheets.
Each sheet gets added via macro as a copy of one existing form sheet. Each sheet then uses relative references to one "data" sheet, where all values are stored. However, the excel freezes even when adding empty sheets. Im not sure if I'm facing kind of HW RAM limit. the file size with 176 sheets is about 7,5 MB. RAM usage according to task manager is 230 MB.
Any idea whys this may be happening would help me.
I appreciate any help or idea for improvement.
Im facing an issue with excel file when working with 100+ sheets.
Each sheet gets added via macro as a copy of one existing form sheet. Each sheet then uses relative references to one "data" sheet, where all values are stored. However, the excel freezes even when adding empty sheets. Im not sure if I'm facing kind of HW RAM limit. the file size with 176 sheets is about 7,5 MB. RAM usage according to task manager is 230 MB.
Any idea whys this may be happening would help me.
I appreciate any help or idea for improvement.