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 4 hours 10 minutes ago

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 Wednesday, May 06, 2015 1:36 AM

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"

• Marked as answer by TechBangalore 19 hours 29 minutes ago

Not able to reproduce this issue anymore neither with 2013 fresh file as #GeorgeZhao indicated nor with 2010 file.  Possibly there was an auto update that came with corrections :).