Excel 2002 Data Sort Function

[daniel g]

I am running Windows XP and Office 2002. While in an
Excel spreadsheet I cannot get "data sort" to function at
all. The system will not allow me to access it (it is
not in bold font). I have tried to reinstall and repair
and cannot make it work. My other computer which is
Microsoft 2000 and Office 2000 works fine. I can access
every command under "data" with the exception of "sort".
Obviously, the "sort ascending" and "sort descending"
commands on the toolbar line are not accessible either.

Thanks much.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to daniel g.
Please use the newsgroup for further discussion.]

I have never come across such a problem; searching
support.microsoft.com didn't help either. Does this happen with just
one particular workbook? Or with all workbooks? What if you create a
new workbook?

Does the new computer have any add-ins / macros installed that are
absent from the old computer?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

 

[mlindsay]

Make sure protection is turned OFF on the worksheet.

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to daniel g.
Please use the newsgroup for further discussion.]

I have never come across such a problem; searching
support.microsoft.com didn't help either. Does this happen with just
one particular workbook? Or with all workbooks? What if you create a
new workbook?

Does the new computer have any add-ins / macros installed that are
absent from the old computer?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

I am running Windows XP and Office 2002. While in an
Excel spreadsheet I cannot get "data sort" to function at
all. The system will not allow me to access it (it is
not in bold font). I have tried to reinstall and repair
and cannot make it work. My other computer which is
Microsoft 2000 and Office 2000 works fine. I can access
every command under "data" with the exception of "sort".
Obviously, the "sort ascending" and "sort descending"
commands on the toolbar line are not accessible either.

Thanks much.

 

[Alex]

I have the exact same problem and protection is turned
off. Any other ideas out there?

-----Original Message-----
Make sure protection is turned OFF on the worksheet.

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to daniel g.
Please use the newsgroup for further discussion.]

I have never come across such a problem; searching
support.microsoft.com didn't help either. Does this happen with just
one particular workbook? Or with all workbooks? What if you create a
new workbook?

Does the new computer have any add-ins / macros installed that are
absent from the old computer?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

 

[Tushar Mehta]

Did you look at any of the questions I asked?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

I have the exact same problem and protection is turned
off. Any other ideas out there?

-----Original Message-----
Make sure protection is turned OFF on the worksheet.

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to daniel g.
Please use the newsgroup for further discussion.]

I have never come across such a problem; searching
support.microsoft.com didn't help either. Does this happen with just
one particular workbook? Or with all workbooks? What if you create a
new workbook?

Does the new computer have any add-ins / macros installed that are
absent from the old computer?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

.

 

[mlindsay]

You might also try the following in an immediate debug window:

application.CommandBars.ActiveMenuBar.Controls("&data").commandbar.controls(
"&Sort...").enabled = True

In testing if I set it to false the Sort option is grayed out and remains so
even if I completely close Excel and then open a new book.
--
Michael R. Lindsay NCT
(e-mail address removed)
(An old dog still trying
to learn new tricks...)

Did you look at any of the questions I asked?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

I have the exact same problem and protection is turned
off. Any other ideas out there?

-----Original Message-----
Make sure protection is turned OFF on the worksheet.

[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to daniel g.
Please use the newsgroup for further discussion.]

I have never come across such a problem; searching
support.microsoft.com didn't help either. Does this happen with just
one particular workbook? Or with all workbooks? What if you create a
new workbook?

Does the new computer have any add-ins / macros installed that are
absent from the old computer?

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP - Excel

@optonline.net says...
I am running Windows XP and Office 2002. While in an
Excel spreadsheet I cannot get "data sort" to function at
all. The system will not allow me to access it (it is
not in bold font). I have tried to reinstall and repair
and cannot make it work. My other computer which is
Microsoft 2000 and Office 2000 works fine. I can access
every command under "data" with the exception of "sort".
Obviously, the "sort ascending" and "sort descending"
commands on the toolbar line are not accessible either.

Thanks much.



.

 

[cheetahtom]

this is not overly pertaining to this thread, but i am forum ignorant and cant seem to to figure out how to post a new question....
I am trying to write an excel function to auto sort columns in a different way by one step for each sort.

Sort 1; sort column A, B, C descending from A

Sort 2; sort column A, B, C descending from B

Sort 3; sort column A, B, C descending from C

any help would be great or even just let me know that it cant be done...

Thank you!!