novicegeek
Member
First off, I’m an Excel idiot. I use Word exclusively, and only use Excel when it’s someone else’s document and I don’t have a choice. Now would be one of those times. I do want to learn, but right now, I’m an idiot.
At work, there’s an Excel spreadsheet that freezes when trying to sort alphabetically. It hogs the memory so much that we can’t do anything with it. Granted, the computers at work are crap (Intel Pentium G3220 with 4 GB of RAM), but when I put this spreadsheet on my computer at home, it was hogging 7 GBs of RAM, and taking a few minutes to complete the task.
The file size is 1.47 MB, not big. To my knowledge, and according to the author, there are no formulas, macros, or calculations on it. It’s really just a list of names divided by work area (should have used Word, right). Other spreadsheets appear to work fine on computers at work, and my computer at home.
I was told the spreadsheet was created on 2010; the computers at work are running 2019. I’m running 365. There are three separate workbooks (pages)within the spreadsheet. We did recently change from Windows 7 Enterprise to Windows 10, if that makes any difference at all.
Thus far, I have cleared the rules from the entire spreadsheet (under conditional formatting) and unmerged all the cells, because there was a message about that when I tried to sort. I event tried to save it in an .xls format. Nothing has helped.
Would some kind soul step forward with a possible solution to this memory hogging spreadsheet? I would greatly appreciate it, as would many other people. Thanks.
At work, there’s an Excel spreadsheet that freezes when trying to sort alphabetically. It hogs the memory so much that we can’t do anything with it. Granted, the computers at work are crap (Intel Pentium G3220 with 4 GB of RAM), but when I put this spreadsheet on my computer at home, it was hogging 7 GBs of RAM, and taking a few minutes to complete the task.
The file size is 1.47 MB, not big. To my knowledge, and according to the author, there are no formulas, macros, or calculations on it. It’s really just a list of names divided by work area (should have used Word, right). Other spreadsheets appear to work fine on computers at work, and my computer at home.
I was told the spreadsheet was created on 2010; the computers at work are running 2019. I’m running 365. There are three separate workbooks (pages)within the spreadsheet. We did recently change from Windows 7 Enterprise to Windows 10, if that makes any difference at all.
Thus far, I have cleared the rules from the entire spreadsheet (under conditional formatting) and unmerged all the cells, because there was a message about that when I tried to sort. I event tried to save it in an .xls format. Nothing has helped.
Would some kind soul step forward with a possible solution to this memory hogging spreadsheet? I would greatly appreciate it, as would many other people. Thanks.