Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2019, 10:52 AM
skeezix skeezix is offline Sort Function Is Greyed Out in One File Windows 10 Sort Function Is Greyed Out in One File Office 97-2003
Competent Performer
Sort Function Is Greyed Out in One File
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default Sort Function Is Greyed Out in One File

I'm using Excel 2000 on a Windows 10 computer.

One of the Excel files that I've been working on for several years all of a sudden will not sort on any of its worksheets. Yesterday it worked fine. All the other files sort correctly. Today that file's Sort function is greyed out. I compared the options from a good file to this file and everything is identical. I restarted Excel but it did not fix the problem. I restarted the computer and that did not fix the problem.



What else can I check to see what the problem might be?
Reply With Quote
  #2  
Old 06-15-2019, 01:32 PM
Alansidman's Avatar
Alansidman Alansidman is offline Sort Function Is Greyed Out in One File Windows 10 Sort Function Is Greyed Out in One File Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

Maybe upload the file here for analysis.
Reply With Quote
  #3  
Old 06-16-2019, 05:12 AM
skeezix skeezix is offline Sort Function Is Greyed Out in One File Windows 10 Sort Function Is Greyed Out in One File Office 97-2003
Competent Performer
Sort Function Is Greyed Out in One File
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

I never did fix the file.
Thank God for backup files...
Reply With Quote
  #4  
Old 06-16-2019, 05:31 AM
Alansidman's Avatar
Alansidman Alansidman is offline Sort Function Is Greyed Out in One File Windows 10 Sort Function Is Greyed Out in One File Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

Good on You.
Reply With Quote
  #5  
Old 06-20-2019, 08:16 AM
skeezix skeezix is offline Sort Function Is Greyed Out in One File Windows 10 Sort Function Is Greyed Out in One File Office 97-2003
Competent Performer
Sort Function Is Greyed Out in One File
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

(Removed by the original poster)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort transaction file into Sales Summary Rogiv Excel 3 05-10-2019 12:46 AM
Zoom Greyed out Wire Rope Man Word 2 06-08-2018 07:19 AM
Word 2013 in Windows 8.1 - File/Options greyed out cprelude Word 0 09-14-2016 10:18 AM
Sort Function Is Greyed Out in One File Use some sort of onload function to check whether template version uses the latest template. zzzjoshzzz Word VBA 5 10-17-2015 10:31 PM
hey guys, need to edit a certain part of a word file but its greyed out winter83 Word 0 08-17-2010 07:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft