Office 2007

[need2bead]

Excel is not responding to my command to sort a-Z
I have a data base set up in Excel and now it will not sort new members into
A-Z order.
I receive this message : Excel cannot complete this task with available
resources. Choose less data or close other applications.

Now I have shut down programs running in the background, I have selected
ONLY the current range on the sheet, and now I am asking for help.

I have used this data for almost three years and this is a recent bug.

Before when I asked it to sort I was prompted to include the data that was
included in my table, "expand the sort to include other data associated with
this column.

I am baffled,peplexed, and down right frustrated!!!

 

[Jan Karel Pieterse]

Hi Need2bead,

Excel is not responding to my command to sort a-Z
I have a data base set up in Excel and now it will not sort new members into
A-Z order.
I receive this message : Excel cannot complete this task with available
resources. Choose less data or close other applications.

How large is your table?
Is this a complex workbook?

Have a look at this page:

www.jkp-ads.com/articles/corruptfiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com