Paste in the Filter search field does not work

%3CLINGO-SUB%20id%3D%22lingo-sub-1273868%22%20slang%3D%22en-US%22%3EPaste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1273868%22%20slang%3D%22en-US%22%3E%3CP%3EGuys%2C%20for%20some%20reason%20my%20paste%20does%20not%20work%20on%20my%20filters%20in%20Excel%20on%20my%20work%20pc%20-%20it%20simply%20does%20not%20even%20respond.%20Otherwise%20in%20any%20other%20field%20it%20works.%20I%20have%20no%20issues%20with%20this%20on%20my%20Mac%20Excel%20version%20which%20in%20this%20case%20is%20just%20truly%20perplexing.%20Any%20ideas%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1273868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1274366%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274366%22%20slang%3D%22en-US%22%3EIs%20this%20in%20any%20workbook%20which%20has%20a%20filter%3F%20What%20happens%20if%20you%20first%20open%20Excel%20in%20safe%20mode%20(press%20and%20hold%20the%20control%20key%20immediately%20after%20launching%20Excel%20from%20its%20icon%20or%20in%20the%20Start%20menu)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1274370%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F605651%22%20target%3D%22_blank%22%3E%40luka23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that%20is%20for%20some%20concrete%20file%20try%20to%20rebuild%20it.%3C%2FP%3E%0A%3CP%3EIf%20that%20is%20for%20any%20file%20try%20to%20repair%20the%20Office.%3C%2FP%3E%0A%3CP%3EIf%20that%20is%20on%20other%20PC%3As%20at%20your%20work%20with%20the%20same%20build%2C%20perhaps%20some%20bug%20for%20concrete%20build%2C%20but%20I%20don't%20remember%20it%20was%20such.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275402%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275402%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20Sergei%20for%20your%20response.%20Unfortunately%20this%20happens%20even%20in%20safe%20mode%20(opened%20it%20up%20via%20Ctrl%2BExcel)%20and%20normal%20mode%20with%20new%20or%20existing%20data.%20Others%20in%20my%20organization%20do%20not%20have%20this%20issue%20and%20I%20already%20checked%20for%20updates%20on%20Excel%20and%20it%20stated%20that%20all%20is%20up%20to%20date.%20I%20guess%20I%20will%20need%20to%20reinstall..%20it%20is%20just%20strange%20that%20everything%20else%20works%20fine%2C%20just%20this%20one%20feature%20until%20now%20that%20is%20as%20I%20am%20still%20nw%20in%20this%20org.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275428%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThank%20you%20Jan.%20Safe%20mode%20does%20not%20seem%20to%20fix%20the%20issue.%20It%20happens%20on%20spreadsheets%20that%20I%20download%20and%20set%20a%20filter%20on%20or%20new%20ones%20where%20I%20just%20create%20bogus%20data%20to%20see%20if%20the%20issue%20persists%20and%20it%20does..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1276191%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1276191%22%20slang%3D%22en-US%22%3EThis%20may%20be%20a%20user%20profile%20corruption.%20Does%20it%20work%20if%20you%20logon%20on%20a%20different%20machine%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281853%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281853%22%20slang%3D%22en-US%22%3EPlease%20send%20feedback%20about%20this%20from%20inside%20Excel.%20Click%20the%20feedback%20button%20and%20mention%20this%20post.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282702%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BHi%20Jan.%20I%20will%20submit%20this%20to%20Microsoft%20over%20feedback.%20This%20is%20my%20only%20Windows%20machine%20currently%20at%20home%20so%20I%20have%20no%20way%20of%20testing%20it%20out.%20Everyone%20else%20at%20work%20does%20not%20have%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282743%22%20slang%3D%22en-US%22%3ERe%3A%20Paste%20in%20the%20Filter%20search%20field%20does%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282743%22%20slang%3D%22en-US%22%3EAt%20home%20you%20could%20try%20to%20add%20a%20new%20user%20to%20see%20if%20it%20works%20when%20you%20logon%20as%20that%20user.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Guys, for some reason my paste does not work on my filters in Excel on my work pc - it simply does not even respond. Otherwise in any other field it works. I have no issues with this on my Mac Excel version which in this case is just truly perplexing. Any ideas? Thank you

8 Replies
Highlighted
Is this in any workbook which has a filter? What happens if you first open Excel in safe mode (press and hold the control key immediately after launching Excel from its icon or in the Start menu)
Highlighted

@luka23 

If that is for some concrete file try to rebuild it.

If that is for any file try to repair the Office.

If that is on other PC:s at your work with the same build, perhaps some bug for concrete build, but I don't remember it was such.

Highlighted

@Sergei Baklan Thanks Sergei for your response. Unfortunately this happens even in safe mode (opened it up via Ctrl+Excel) and normal mode with new or existing data. Others in my organization do not have this issue and I already checked for updates on Excel and it stated that all is up to date. I guess I will need to reinstall.. it is just strange that everything else works fine, just this one feature until now that is as I am still nw in this org.

Highlighted

@Jan Karel Pieterse Thank you Jan. Safe mode does not seem to fix the issue. It happens on spreadsheets that I download and set a filter on or new ones where I just create bogus data to see if the issue persists and it does..

Highlighted
This may be a user profile corruption. Does it work if you logon on a different machine?
Highlighted
Please send feedback about this from inside Excel. Click the feedback button and mention this post.
Highlighted

@Jan Karel Pieterse Hi Jan. I will submit this to Microsoft over feedback. This is my only Windows machine currently at home so I have no way of testing it out. Everyone else at work does not have the issue.

Highlighted
At home you could try to add a new user to see if it works when you logon as that user.