baadams
Board Regular
- Joined
- Mar 2, 2006
- Messages
- 134
This one has me stumped. We have a fairly simple Excel file around 2MB. When you open it, and view the task manager Excel is using 1.6GB of physical memory with only this one file open. What could be causing it to use so much computer memory. You can only navigate the file for a couple minutes before Excel warns you that you don't have enough memory. The more you navigate the file the more memory Excel starts using.
There are no data connections. It's an .xlsx file with no VBA. It has no external links. I can't find any hidden functions. I've tried deleting all of the functions I can find and it changes it very little.
I can hardly work in the file for more than a couple minutes before it becomes useless. The file acts like it's very large, but it's small in comparison to other files we use that function normally.
I can re-build the file, but my curiosity has gotten the best of me.
Thanks for the help.
There are no data connections. It's an .xlsx file with no VBA. It has no external links. I can't find any hidden functions. I've tried deleting all of the functions I can find and it changes it very little.
I can hardly work in the file for more than a couple minutes before it becomes useless. The file acts like it's very large, but it's small in comparison to other files we use that function normally.
I can re-build the file, but my curiosity has gotten the best of me.
Thanks for the help.