Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1076
  • Last Modified:

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
0
Damian_Gardner
Asked:
Damian_Gardner
  • 2
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Have you tried storing the values in column H (and other columns as well) as numbers rather than text?
0
 
redmondbCommented:
Hi, Damian.

It didn't even make it to Col. H for me - crashed on B!

The file is corrupt. I did a quick and dirty rebuild on it by copying the sheets to a new file. It's sorting fine now.

Regards,
Brian. AX---FARM---CONTRACTS---USD----9.xls
0
 
Damian_GardnerAuthor Commented:
great - let me try it...
0
 
Damian_GardnerAuthor Commented:
Works great.  thanks alot.
0
 
redmondbCommented:
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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now