Small spreadsheet (< 1 mb) uses 4 Processors and runs very slowly

[JRogersOU]

Hey everyone.

I have a pretty simple spreadsheet downloaded from an Access database. It has 7 columns of data (small numbers or strings) and about 1000 rows. There are no special formulas, characters, characters, or conditional formatting. It is just numbers and/or text. The file size is 812 KB.

The issue is every time I make a single change to a cell it begins Calculating 4 Processors. What's worse is the code (I believe simple code) takes hours to run. The only thing the code does is sort the table by one column and copy some pertinent (condensed) information to another sheet. I've never seen a code that couldn't just crunch through this task at light speed.

I have no other macros associated with the spreadsheet. I am using Excel 2013 and this is a .xlsm worksheet. It is perhaps worth mentioning that the spreadsheet seems to bog down a bit even before I start putting code behind it.

Any help is appreciated. Thanks!

 

[igold]

There is obviously more to the spreadsheet than meets your eye. 7 columns with a 1000 rows of data should be 30-35 kb. You might want to check for phantom ranges. I would manually go to each sheet and click Ctrl + End, that will take you to where Excel thinks the last cell with data is.

Does the spreadsheet take longer to open than you would expect.