Guys I got one very annoying problem related to memory management of excel. I have one file of size 4.75 MB and it's a ".xlsm" file meaning it has some very basic general routines related to management of my various sheets. I got 275 sheets in the workbook. Whenever i am working on sheet (saving some data and data entry), sometimes the memory just shoots up and at times it consumes more than 1GB of memory. What is the reason behind this and why it is happening? I have attached screenshot of my "Task Manager" showing memory taken by that file.
Any help and guidance is highly appreciated.
Any help and guidance is highly appreciated.