I recently upgraded from Office 2010 to Office 2013.  Unlike the previous versions of Excel, the data filter in Excel 2013 disappears.  Save the Excel with filters applied, close and reopen the file, filter is not retained.  Even the filter mark is not to be seen.  Not sure if its a bug, but there are other tiny such bugs were encountered in 2013 Excel.

• Moved by Lanlan HuangMicrosoft contingent staff Thursday, April 23, 2015 2:18 AM

Hi,

Based on my test, Data filter does not lost when we re-open the file in Excel 2013. Thus, I think it is not a bug. Thus, please provide us more information to assist you better.

• Did this issue occur with the previous file that created with Office 2010?
• Have you tried to re-create a new file to test?

If this issue occur only with the previous file that created with Office 2010, this issue might be caused by the file compatibility, pleases use compatibility checker to update the files:

https://support.office.com/en-ca/article/Check-file-compatibility-with-earlier-versions-d9856881-5875-4c58-915f-06859b2943a7

If this issue occur with all files even with a new file, please try to repair Office 2013.

Hope it's helpful.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, April 24, 2015 3:20 AM

Hi,

Based on my test, Data filter does not lost when we re-open the file in Excel 2013. Thus, I think it is not a bug. Thus, please provide us more information to assist you better.

• Did this issue occur with the previous file that created with Office 2010?
• Have you tried to re-create a new file to test?

If this issue occur only with the previous file that created with Office 2010, this issue might be caused by the file compatibility, pleases use compatibility checker to update the files:

https://support.office.com/en-ca/article/Check-file-compatibility-with-earlier-versions-d9856881-5875-4c58-915f-06859b2943a7

If this issue occur with all files even with a new file, please try to repair Office 2013.

Hope it's helpful.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, April 24, 2015 3:20 AM
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 57 minutes ago

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"