Excel freezes when filtering

Excel freezes when filtering DEFAULT

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. These types of problems may occur for one or more of the reasons listed below.

Follow the provided solutions in this article in order. If you have previously tried one of these methods, and it did not help, please go to the next solution in the list.

Start Excel in safe mode

Safe mode lets you start Excel without encountering certain startup programs. You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. However, COM add-ins are excluded.

If your issue is resolved after you run Excel in safe mode, see: How to troubleshoot startup problems in Excel.

If your issue is not resolved after you start Excel in safe mode, continue on to the next item on this list.

Install the latest updates

You might need to set Windows Update to automatically download, and install recommended updates. Installing any important recommendation, and optimal updates can often correct problems by replacing out-of-date files and fixing vulnerabilities. To install the latest Office updates, follow the steps in this article: Update Office and your computer.

If installing the latest Office updates did not resolve your issue, continue on to the next item on this list.

Check to make sure Excel is not in use by another process

If Excel is in use by another process, this information will be displayed in the status bar at the bottom of the Excel window. If you try to perform other actions while Excel is in use, Excel may not respond. Let the task in process finish its job before attempting other actions.

If Excel is not is use by another process, continue on to the next item on the list.

Investigate possible issues with add-ins

While add-ins can enhance your experience, they can occasionally interfere, or conflict with Excel. Try starting Excel without add-ins to see if the problem goes away. 

  1. Do one of the following:

    • If you are running Windows 10, choose Start > All apps > Windows System > Run > type Excel /safe in the Run box, then click OK.

    • If you are running Windows 8, click Run in the Apps menu > type Excel /safe in the Run box, then click OK.

    • If you are running Windows 7, click Start > type Excel /safe in Search programs and files, then click OK.

  2. If the issue is resolved, click File > Options > Add-ins.

  3. Select COM Add-ins, and click Go.

  4. Clear all the check boxes in the list, and click OK.

  5. Close and restart Excel.

If the issue does not occur when you restart Excel, start enabling your add-ins one at a time until does. This will allow you to figure out which add-in is causing the problem. Be sure and restart Excel each time you enable an add-in.

If disabling add-ins did not resolve your issue, continue on to the next item on the list.

Investigate Excel file details and contents

Excel files can exist on the computer for a long time. They are upgraded from version to version, and frequently travel from one user to another user. Frequently, a user inherits an Excel file but doesn't know what is included in the file. The following things can cause performance or crashing issues:

  • Formulas referencing entire columns.

  • Array formulas referencing an uneven number of elements in the arguments.

  • Hundreds, or perhaps thousands of hidden or 0 height and width objects.

  • Excessive styles caused by frequent copying and pasting between workbook.

  • Excessive, and invalid defined names.

If these steps do not resolve your issue, continue on to the next item on the list.

Check whether your file is being generated by a third party

Sometimes Excel files are generated by a third-party application. In this case, the files may be generated incorrectly, and some features may not work properly when you open the files in Excel. If this occurs, test the features in new files outside the third-party application. If the features work correctly, you should make sure that the third party is aware of the issue.

If your issue is not resolved after you test it outside the third-party application, continue on to the next item on the list.

Perform a selective startup to determine whether a program, process, or service conflicts with Excel

When you start Windows, several applications and services start automatically, and then run in the background. These applications and services can interfere with other software on your PC. Performing a selective startup (also known as a "clean boot") can help you identify problems with conflicting applications. To perform a selective startup, choose one of the following links depending on your version of Windows, then follow the steps in the article:

Windows 10, Windows 7, Windows 8: Run Selective Startup using System Configuration
Windows Vista: Run Selective Startup using System Configuration
Windows XP: How to create and configure user accounts in Windows XP

Selective startup is used to help identify the offending process, service, or application that conflicts with Excel.

If your issue is not resolved after you re-create the profile, continue on to the next item on the list.

Repair your Office programs

Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. For instructions on doing this, see: Repair an Office application.

If repairing your Office programs did not resolve your issue, continue on to the next item on the list.

Check to see if your antivirus software is up-to-date or conflicting with Excel

If your antivirus software is not up-to-date, Excel may not function properly.

Check whether your antivirus software is up-to-date:

To keep up with new viruses that are created, antivirus software vendors periodically provide updates that you can download from the Internet. Download the latest updates by visiting your antivirus software vendor’s website.

For a list of antivirus vendors, see: Consumer security software providers.

Check whether your antivirus software is conflicting with Excel:

If your antivirus software includes integration with Excel you may experience performance issues. In this case, you can disable all Excel integration within the antivirus software. Or, you can disable any antivirus software add-ins that are installed in Excel.

Important: Changing your antivirus settings may make your PC vulnerable to viral, fraudulent or malicious attacks. Microsoft does not recommend that you attempt to change your antivirus settings. Use this workaround at your own risk.

You may have to contact your antivirus software vendor to determine how to configure your software to exclude any integration with Excel or to exclude scanning in Excel.

More Information

Advanced troubleshooting

If the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific, or environmental. The following section describes how to troubleshoot additional issue that can cause Excel to hang, or crash. 

Environmental factors

Environmental factors are just as important as file contents, and add-ins when you are troubleshooting crashes. You can help determine the cause of your issue by taking the following actions:

  • Follow basic troubleshooting steps.

  • Test files in the cleanest possible environment.

The following sections describe some areas that are worth investigating.

Where the file is stored

Moving the file locally will help determine whether there is something wrong with the file, or with where the file is saved. Several issues can arise when you save an Excel file over a network or to a web server. It is a good idea to save the file locally. This should be done in the following scenarios:

• Redirected "My Documents" folder to server location

• Offline files

• Opening files from a Webfolder or SharePoint

• Remote Desktop/Citrix

• Network appliances

• Virtualized environment. For more information about Microsoft software that is running in a virtualized environment, see the following article: Support policy for Microsoft software running in non-Microsoft hardware virtualization software.

Memory

Excel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application. For system requirements of the Microsoft Office suites, go to the following Microsoft articles: 

System requirements for Office 2016

System requirements for Office 2013

System requirements for Office 2010

System requirements for Excel 2007


Office 2010 introduced native 64-bit versions of Office products to take advantage of larger processing capacities. To read more about 64-bit editions of Office, go to the following Microsoft articles:

64-bit editions of Office 2013

Understanding 64-bit Office

Printers and video drivers

When you start Excel, it examines the default printer and video drivers that will display your Excel workbooks. Excel is printer-intensive, and it will run slower when Excel files are saved in Page Break Preview view. Testing a file by using different printers such as the Microsoft XPS Document Writer printer driver, or the VGA video driver will determine whether the problem is with a specific printer or video driver. 

If you still have hanging or crashing issues in Excel after you work through the resolution methods that are mentioned here, you should contact Microsoft Support for guided troubleshooting. 

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Sours: https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4

Excel Freezes When Removing Filters In Large Table

Excel Freezes When Removing Filters In Large Table - Excel

I'm using an Excel (2007, running in Vista) spread sheet to help keep track of information about documents related to my dissertation. Currently this spread sheet has about 2975 rows, and I expect it to grow to 3 or 4 times that many.

I've formatted all the information as a table in order to sort for different key words about these documents. The tables filter with no problem. However, when I attempt to remove the filter, Excel freezes. Normally I can use undo to get back to where I was, but this isn't an option if I've altered rows after sorting.

Each row has many possible terms by which to filter, and yesterday I finally discovered that if I've sorted for one term, I can eventually get back to the full table by filtering for all other terms one or two at the time, but no more. This serves the propose but is time consuming and annoying.

I have two columns of check boxes in this table as well, which sometime seem to behave oddly, although I've figured out ways around it.

I know that a database is probably better suited to what I'm doing, but I'm currently short of money, so I need to make what I have work. Are there any suggestions for solving my problem?

Thanks,
Liz

View AnswerNext Result

Online Excel Courses


Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel (Multiple Methods)

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.




Similar Topics

Excel Won't Filter Whole Column. - Excel

Lock Rows For Filter - Excel

Remove Table Filter Arrows On Some Columns - Excel

In Excel How Can I Filter Multiple Columns Simultaneously? - Excel

Return Data To Original Order After Sorting - Excel

Applying A Filter To Multiple Sheets - Excel

Can I Copy A Table From Word Into One Cell In Excel Without Losing Data? (of - Excel

Filter For Multiple Text Words - Excel

Filtering A Pivot Table Based On The Value Of A Cell - Excel

Putting A Table Into A Userform - Excel

Filtering Data Horizontally - Excel

Select Filtered Data Using Vba Code - Excel

Filter By Color Not Working - Excel

Unable To Create Pivot Table In Existing Worksheet - Excel

Drag And Fill Overwrites Filtered Data - Excel

Move To Next Cell Down When Filtered - Excel

Worksheet Not Scrolling Down - Excel

How Do You Delete Filtered Rows In An Autofiltered List. The Row. - Excel

Quick Vba Question: Checking If A Filter Is Applied - Excel

Using Countif Formula In A Pivot Table - Excel







Hi!

I have a question regarding filtering of columns, hopefully someone is able to put me on the right track. I have set up Excel 2007 so that I can click on the drop-down menu in each column to filter them.

However, in my data set there is one blank row separating two set of rows. Now, when I apply the filter on a column, all the rows above the blank row filter correctly, but all the rows below stay un-filtered.

I guess Excel only looks at the consequtive rows, then stops when it hits a blank row. Is there any way of applying the filter beyond a blank row (i.e. the whole column)?

Any advice is higly appreciated.

View Answers
View Answers

I feel like this should be really easy and I am just out of it today but I cannot figure this out. I want to lock a row and filter (with filter,not sort, tool) the other rows. I attached an example

The row in RED I want to never be changed or added in the filter, but I want row 2 and 1 to filter together. So I want (in this case) the flavor to filter with the same number. SO i guess the filter process would be dependent upon the total number of votes. Any ideas? Thanks!

I had to create the information in tables and went from there. Got it. Thanks!

View Answers
View Answers

Hi,

I made a budget with many narrow columns and have turned the data into a table. I will only ever filter the data with the left-hand most column. However, all the other columns are filled each with the grey drop-down filter arrow button, and I can no longer see the headings of these columns and frankly seeing 50 little unused arrow buttons is rather ugly. Is there any way to simply remove the filter drop-down buttons on some columns or even all of them, just leaving a filter button at the heading of the first column? I know I can hide the headings, but then I lose sight of the first filter arrow that I use.

Sorry to ask such a bizarre question, but I appreciate your help.

Thanks

View Answers
View Answers

I'm attempting to filter columns E, G, and I all at the same time. I need to
display rows that have values greater than 0 in any one of those three
columns. So far I can only filter progressively. If I filter column E and
then filter column G, the second filter is only applied to the results of the
first filter.

Does anybody know if it's even possible to do what I'm trying to do?


View Answers
View Answers

Good mornng - I am new to the forum - my name is Jena

My question is this - I have a large spreadsheet with multiple columns of information. I want to sort it by a certain column. I know how to do this. My question is, once I'm done with my work I want to sort it back to the original "sort" but I'm not sure how they have it sorted. I've tried to figure out how they have it sorted but can't. Is there some way to go back to the original sort?

Thank you for your anticipated help.

Jena

View Answers
View Answers

Is it possible to apply a filter to multiple sheets within the same Excel workbook, using the same filter criteria?

For example, suppose you have tables of data on 3 different tabs, all having the same headings. Suppose one of the headings is "gender". If you apply a filter to the table on Sheet 1, to only show the rows containing the word "female", is it possible to have the tables on Sheets 2 and 3 automatically update to only show the "female" rows? Or would you have to manually update the filter criteria in Sheets 2 and 3?

I hope this makes sense. Thank you in advance for any help.

View Answers
View Answers

I would like to copy a small table from Word into one cell in an Excel
worksheet. The first column of the table is a list of numbers. I tried
converting the table into text with manual line breaks and tab stops to
divide columns and rows, but that didn't solve my problem.

Excel pastes the data into several rows. When I try to merge them, I
get a warning that the selection contains multiple data values, and
merging into one cell keeps the upper-left most data only.

What I tried that didn't work:
* Formatting the Excel cells as text before pasting the data.
* The various options for "Paste Special." The closest I got was
inserting the table as a Document Object, which could be a workaround,
I guess.
What I am saving for when all else fails:
* The obvious solution of copying row by row into one Excel cell.

The data in the table is information about my dad's medications. I
would like to have reference charts of how to identify the strength of
each tablet by its color and markings. I got the info from the
manufacturers' websites and entered it into tables in Word, which I
would like to copy into a more comprehensive file I am creating in
Excel. The first column of each table is the strength of the tablet,
entered as 1 mg., 2 mg., etc. The subsequent columns describe the
shape, color, and markings. There are 3 tables, each with about 4-5
rows.

Is there a way to copy each one - whether as a table or as text - into
a single Excel cell without losing data?

Many thanks.



View Answers
View Answers

I have a long list of item descriptions that I need to filter down to descriptions containing words like "valve" or "ring" or "root" or "epic" (17 key words in all). The basic custom filter looks like it only lets me filter for 2 words.

I have some experience working with advanced filter for things like >100 but that's about it. Any help with this would be so appreciated.

View Answers
View Answers

Hi everyone,

I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell. This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list.

The macro works perfectly for my purposes except in one regard: I can no longer perform a "show all" filter. If I leave the "search bar" cell blank, the pivot table shows nothing. I'm sure that there is an easy fix for this but I'm still learning the basics of how to write and use macros. How can I change the code so that when I leave the cell blank, the pivot table shows all? The search bar cell is D2.

Thanks for your time!

View Answers
View Answers

Hey there,

I have been tasked with introducing userforms into an excel sheet and tbh I'm quite amazed that excel has this capability of adding userforms to excel sheets.

Anyway, I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. The user should then be able to select a particular row and insert it into the specified cell.

I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected...basically so that the user can draw deeper into the information that they require.

I have an example excel sheet where I have 2 sheets. One sheet is the user entry sheet called User Entry Screen. the next sheet is the tables sheet where my tables are held. Once the user selects the cell shown in the example sheet, it should then bring up the user form. the user then, depending on which item clicked, then gets shown the next window with a table and info on it. then user should then be able to select an item and the cells on the user entry screen would then get populated.

Personally I think this is a really tricky challenge and any help with doing this would be extremely appreciated.

I'll post up further comments as I am trying to work my way through it!

Thanks,

Jag

View Answers
View Answers

i know how to use the data filters vertically but have been wondering if its possible to filter data horizontally so i could put a filter on, say column c and sort the data across the sheet rather than down. if its not possible i will find another way to do what i want but this seems to be just what i would need. does anyone know if it can be done?

View Answers
View Answers

I am looking for the code to select the visible data after applying a data filter. Actually I know how to select the data after applying the data filter but the issue is I am not able to exclude the header row and give the target range as used (non-blank) rows only!!

I am using below code to Select the Visible rows in the target range:

Code:

Range("A:p").SpecialCells(xlCellTypeVisible).Select

Problems in this code a

1) after applying the filter, while selecting the data it is selecting all the rows in given range till last row on the workbook. I need this to select the the data only till the last used row in the given range.

2) It is not possible to provide the address of the first row after we apply the filter since the first row address may change depending on the values in the table.

E.g. 1st time when I am running the macro the first row in the visible filtered data is starting at Cell address A4 and next time when I will run the macro it may be A6

3) The Code is also selecting the 1st row which is a header row. How can we exclude it from selection.

Some one please revert with the solution.
Thanks in advance.

View Answers
View Answers

Hi
I am using Excel 2007 and suddenly I can no longer filter by color. The option is greyed out and so is the sort by Color option. Does anyone have any idea why this would happen?

Thanks in advance.

View Answers
View Answers

Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet.

I am running Excel 2011 for Mac.

I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data.
I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it.

Appreciate any help, let me know if you have any further questions.

Hunter

View Answers
View Answers

Hi there. I'm using Excel 2007 and often use filters to find inconsistent data (mis-spellings, etc.) and then clean up the data using the fill handle to fill in correctly formatted values. I'm finding that, with a simple filter on, dragging over cells hidden by the filter changes the values in the hidden cells too. This is something I don't remember from my last version of Excel. I'm wondering if I've mis-remembered how this control works, or if there is a setting I can't find.

My goal is to drag and fill (or paste) in a colum with a range of rows wiht some hidden (filtered out) rows, and have the filtered out data be unaffected, if that makes sense.

Thanks!

T

View Answers
View Answers

Hi there,

I am currently using 'Activecell.Offset(1,0).Select' to move down one cell at a time when I click on a button.

The problem I have now is that if someone was to filter by something then the 'next cell down' could be hidden behind the filter (by that I mean it didn't meet the filter criteria).

Is there anyway to move down to the next row, even if that row does not follow on Sequentially .

Any help would be greatly appreciated.

Regards,

James

View Answers
View Answers

Hi All,

Random question i have a large Excel Workbook (which is protected) and has over five sheets on it - however one sheet has randomly decided not to scroll... yes i know sounds random! If i use the cursor and down arrows the selection just disappears off the screen.
The page will scroll if i filter by one field, but not if i select (All) for all filters.
All other worksheets scroll fine.
Any suggestions?

Thanks in advance.
Cheers Kaite

View Answers
View Answers

When I auto filter a spreadsheet, I can't figure out how to delete or
eliminate from the sheet the filtered-out rows. So when I refilter the sheet
with new items to get rid of, the old filtered items come back. I've tried
copying the range to another file, but I always get all the old data in the
new file.


View Answers
View Answers

Hi,

I am using

ActiveSheet.ShowAllData

in a piece of VBA and it causes an error if the sheet does not have a filter applied! Is there an if statement I can use to check if the data is filtered?

Thanks - this site is an absolute life saver!

Rich

View Answers
View Answers

Hi,

Im working with a large data spreadsheet that has Yes and No answers in different columns. There are blanks within the selection too.
I need to calculate only the Yes.
I have tried using the filters in the Pivot Table field list and they are not working.
So now i'm trying to add a COUNTIF formula in the Calculated Fields section.
The formula I'm using is =Countif('Time limit extension'="yes") and i get the answer "too few."
What should I be using in the formula to get the calculated field to work? I have search the whole forum and I haven't found an answer that can help me.

Please HELP!!!

View Answers
View Answers

Sours: https://www.excelcommand.com/excel-help/excel-how-to.php?i=329217
  1. Happy birthday hilary images
  2. Graco baby bassinets
  3. Framed wallpaper samples
  4. Naruto characters images
  5. Xunit nuget

Why does excel freeze when I filter?

If you're experiencing crashes when using a filter in Excel, it could be that there's a corruption on the file you're working on or on the app itself. Opened excel file, applied filter and excel crashed. Copied file to non-one drive folder, opened and file was filtered as per request that caused crash. Closed file.

Click to see full answer.


Similarly one may ask, why does my Excel spreadsheet keep freezing?

Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. For instructions on doing this, see: Repair an Office application. If repairing your Office programs did not resolve your issue, continue on to the next item on the list.

Also Know, how do you stop Excel from not responding without losing data? How to Fix Excel Not Responding Problem

  1. Install the Latest Microsoft Office.
  2. Open and Save Excel in Safe Mode.
  3. Make sure Excel Is Not in Use by Another Process.
  4. Disable Add-ins.
  5. Check for the Program Conflict.
  6. Update or Close Anti-virus Software.
  7. Repair Microsoft Office.
  8. Uninstall and Reinstall Office.

Correspondingly, how do you unfreeze a filter in Excel?

To unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu. Now when you move around in your spreadsheet, columns and rows should display as normal.

How do I speed up filtering in Excel 2016?

Slow calculation & slow filter excel 2016

  1. disable animations, hardware acceleration.
  2. enable / disable iterative calculation.
  3. open in safe mode.
  4. switch between 64 and 32 bit version of office.
  5. clean up all formats.
  6. set it to use all (8) processors.
  7. change the default printer to xps document writer.
Sours: https://askinglot.com/why-does-excel-freeze-when-i-filter
Excel: Freeze Panes and View Options

Hi Plantman UK,

If you're experiencing crashes when using a filter in Excel, it could be that there's a corruption on the file you're working on or on the app itself. Since you mentioned that the issue seems to happen on shared files in OneDrive, I suggest checking if the issue will still occur on files not saved to OneDrive or shared OneDrive.

In the meantime, you may also use the Online Repair. This tool is used to check and repair corruptions in Office applications. Refer to this article for the troubleshooting steps. Make sure to choose the correct operating system of your PC to start repairing Excel.

If you continue to have this issue even after performing the above steps, please reply to this thread. The system will notify me so I can get back to you and provide you more answers.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Ok did fix. Opened excel file, applied filter and excel crashed. Copied file to non-one drive folder, opened and file was filtered as per request that caused crash. Closed file. Opened onedrive version and again file was filtered as per request that caused crash. Unfiltered and manually saved. Filtering seems to work now. 

Find that hard to explain!

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Plantman UK,

If you're experiencing crashes when using a filter in Excel, it could be that there's a corruption on the file you're working on or on the app itself. Since you mentioned that the issue seems to happen on shared files in OneDrive, I suggest checking if the issue will still occur on files not saved to OneDrive or shared OneDrive.

In the meantime, you may also use the Online Repair. This tool is used to check and repair corruptions in Office applications. Refer to this article for the troubleshooting steps. Make sure to choose the correct operating system of your PC to start repairing Excel.

If you continue to have this issue even after performing the above steps, please reply to this thread. The system will notify me so I can get back to you and provide you more answers.

Tried the repair tool. Still have problems with all excel file on shared onedrive directories on multiple pcs. Sounds like a bug to me. MSFT must be getting lots of crash reports from me and my partner who share the files so perhaps they'll look into it. The only solution seems to be to turn off data filtering at start of every session and then turn it on again.  I notice that when we're both working on a worksheet and one filters it the other sees the filter so is it a problem with sharing the filter across onedrive?

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Plantman UK,

If you're experiencing crashes when using a filter in Excel, it could be that there's a corruption on the file you're working on or on the app itself. Since you mentioned that the issue seems to happen on shared files in OneDrive, I suggest checking if the issue will still occur on files not saved to OneDrive or shared OneDrive.

In the meantime, you may also use the Online Repair. This tool is used to check and repair corruptions in Office applications. Refer to this article for the troubleshooting steps. Make sure to choose the correct operating system of your PC to start repairing Excel.

If you continue to have this issue even after performing the above steps, please reply to this thread. The system will notify me so I can get back to you and provide you more answers.

After more testing the crash does NOT occur if autosave is turned off. It seems Excel has a bug with autosave, shared onedrive and filtering that needs fixing.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you for your response. As per reading your post, it seems that the issue has something to do with the OneDrive app. With that, I highly suggest posting this issue in the OneDrive in-app support or the OneDrive Help Center. Here's how you can access the in-app support:

  1. Sign in to OneDrive.com.
  2. Click ? help icon located at the top, select Email OneDrive support.
  3. Submit your concern.
  4. Follow the prompts to request support.

Should you need any other concerns related to our scope of support, kindly post back on this thread.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I have the same issue.  For any excel files that I open from Sharepoint the use of any filter crashes excel and requires it to restart.  When I save the same file down to my c: drive there are no issues.

Please let me know if anyone has found a solution to this one.

Thanks
Ben

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 

 

Sours: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-crash-when-applying-a-filter/7b1757c5-f6e8-44dc-be6b-6c37db6076c0

Filtering excel freezes when

Microsoft Excel freezes

Maybe the issue that causes Excel to freeze has been resolved in the latest update released by Microsoft. Or, if you have updated your computer's operating system to the latest version, maybe it has compatibility issues with the potentially outdated Excel version. Check for updates to Microsoft Excel, and if updates are available, download and install them.

An article by Microsoft suggested that there was an issue between Microsoft Office and Windows 10 Accessibility modules, for which the Microsoft team released updates:

https://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-filtering-problemmatic-after-windows-10/f6f34982-d4e0-47b3-bd37-772fd51e0ff3

You can check for and apply updates to Microsoft Excel, by following the steps below:

  1. Go to File and click on Account;
  2. Click on Update Options and select Update Now, located under Product Information.

On older versions of Microsoft Office:

  1. Go to File and click on Help;
  2. Click on Check for updates.

Note: Feel free to check the article by Microsoft, explaining how to install office updates.

Sours: https://solutionbay.com/solutions/microsoft-excel-freezes
MS Excel - Filtering Data

.

Now discussing:

.



310 311 312 313 314