User Profile
MartinLeG
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
O365 Cloud Excel Filters Not Working
Hi - we have recently moved to O365 and experiencing a lot of difficulty applying filters in the Cloud version. It's very hit and miss - but users are getting very frustrated - sometimes working and sometimes not responsive. (Or sometimes responsive but not showing any row data.) The solution may be to install O365 desktop but the product is designed to work in the cloud so would like to find a solution. We have good internet speed (45mbps) and have tried rebooting machines and/or opening in a different browser, and this sometimes fixes the problem - but not consistent. I'm sure we can't be the first to experience this - so any suggestions very welcome! (And trying to call MS for support is a complete waste of time - 8 different calls to somebody with a baby on her lap in Manilla over the worst telephone connection and no chance of understanding me...grrrr.) Thanks!895Views0likes0CommentsRe: Advanced Filters in Excel
NowshadAhmed Thanks for the follow up and yes, we have had this with standard filter on - but found that it was not filtering all the data in the dataset. Is it not possible to remove the Advanced filter altogether? It doesn't show in any other spreadsheet...3.2KViews0likes1CommentAdvanced Filters in Excel
Hi - we have an advanced filter in place on a shared Excel file - no idea how it got there but we can't get rid of it - and that means our standard filters are not filtering the entire data set. The 'clear' button is greyed out and if I click on the Advanced tab it is displaying list range: $A$1:$U$1. We just want to disable this and ideally prevent it ever being reapplied...3.6KViews0likes5Comments
Recent Blog Articles
No content to show