Sort Problem

I am having a serious problem with sorting a spreadsheet that I have never seen before. For some reason, when I try and sort by some of my categories, the excel spreadsheet simply closes. No warning or error is given, it just closes. There are some levels in place and when i sort with all of the collapsed, I dont have the problem. Unfortunately, I need to be able to sort when all rows are visible. Anyone know what this is happening and a way around it?

Originally Posted by sposdog

I am having a serious problem with sorting a spreadsheet that I have never seen before. For some reason, when I try and sort by some of my categories, the excel spreadsheet simply closes. No warning or error is given, it just closes. There are some levels in place and when i sort with all of the collapsed, I dont have the problem. Unfortunately, I need to be able to sort when all rows are visible. Anyone know what this is happening and a way around it?

Sounds to me like you may have a lot of forumla's for macro's in some of those cells. When you sort, excel doesn't know where to find that data anymore, and crashes. Just a thought though...

Sounds like the file is having a problem. Why don't you copy the data into a new spreadsheet and try to sort in the new spreadsheet. Maybe the file is corrupt.

Hope this helps.