Damian Gardner
asked on
Excel 2010 spreadsheet crashes while sorting
Hello - we have a user whose large spreadsheet crashes consistently while sorting, and it happens on multiple computers, leading me to think it's something within the file itself. What happens is we sort it one-at-a-time, first on Column A "Rep", then on Column B "Cust #", then it crashes on Column H "Group/Part#". Not sure what causes it.
thanks for your thoughts.
AX---FARM---CONTRACTS---USD----9.xls
thanks for your thoughts.
AX---FARM---CONTRACTS---USD----9.xls
Have you tried storing the values in column H (and other columns as well) as numbers rather than text?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great - let me try it...
ASKER
Works great. thanks alot.
Thanks, Damian.
I mentioned "quick and dirty" - one of the things I left out was the print layout. Let me know if you need any help with that.
Regards,
Brian.
I mentioned "quick and dirty" - one of the things I left out was the print layout. Let me know if you need any help with that.
Regards,
Brian.