• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1153
  • Last Modified:

SharePoint 2010 user cannot see custom filter on one laptop but can on another

I am using custom filters on a SharePoint sub site list and depending on the laptop connecting to the SharePoint site the custom filter is not visable (only the data in the column is seen as filters when the custom filter is missing). This is an issue because the client using the site wants to sort the data by ranges equal to, greater than and so on which are only available if the custom filter in the drop down menu is there. I have included a screencap of what it looks like when it is working. Again, when it is not, the custom filter does not appear. Also, again, this occurs for the same user depending on laptop. I have checked the internet security settings and they are the same on a lpatop which works and one that doesn't (I have also tested on an IE8 and IE9 to see if a different version would cause the issue with custom filters but both versions caused no issues).

At this point I am not sure where to look as the user is the same, the version of IE doesn't seem to affect the custom filter and the IE security settings under internet are the same. Any help in other places to look or users who have had simular issues would be appreciated.
SDR-CustomFilter.JPG
0
PaulyGilmour
Asked:
PaulyGilmour
  • 5
  • 5
  • 3
1 Solution
 
Jamie McAllister MVPArchitectCommented:
I've seen this sort of thing due to VPN settings on machine. It looked like the same account but (and I'm struggling to recall here) but one was the domain account and on another machine it was a subtely different account for the same person.

A little vague I know but look at the Accounts logged in on the two machines and confirm they really are the same one.

I remember answering a previous thread on this sort of thing, if I can dig that out I will post the link.
0
 
HankinaterCommented:
Are both laptops running the same version of Office?  

I've also seen weird behavior when the browser is 64-bit and Office is 32-bit.
0
 
PaulyGilmourAuthor Commented:
The access is via URL without VPN using SSL (https://<site>.<domain>.com).

As for Office version installed on the laptops both have a 32 bit Office, though the OS on two which are working are Win 7 32 bit but the one which isn't has a Win 7 64 bit OS and 32 bit Office (this was due to a requirement of a GP Dynamics client application which only works with 32 bit Office)
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
HankinaterCommented:
Be sure they are launching the 32 bit IE and see if it works then.
0
 
PaulyGilmourAuthor Commented:
Indeed using the 64 bit IE doesn't work, has to be 32 bit IE.

BUT I also did a double check and the Office version on the non-working laptop to find out it was 64 bit, not 32 bit (though all Office 2010). I got the user to try the sub site custom filtering on a second laptop at the client site w/ the same IE version, same OS (Win 7 64 bit) but with the 32 bit Office and that functionality worked.

So my conclusion is that indeed:

1) has to IE 32 bit explorer
2) has to be Office 32 bit application
3) OS can be either 32 or 64 bit

Thanks Hankinator for the suggestion. The user hasn't changed bit version of Office on the non-working laptop but given the testing I think once she does switch to the 32 bit version of Office 2010 it will work.
0
 
HankinaterCommented:
PaulyGilmour - the issue I pointed out was that if you are using a 64-bit version of Office and a 32-bit version of IE and try to open the site the filter doesn't show because you don't have a compatible version (bit-wise).  Because Windows OS 64-bit installs both bit versions of IE, you should use the compatible version of IE (in other words same bit version as your Office install).

I believe I should get credit for the answer - but ultimately it is up to you.

Hank
0
 
Jamie McAllister MVPArchitectCommented:
Hankinater deserves some credit for his suggestion of checking whether MS Office is x32 or x64 in my humble opinion.

I suggest answer 38295567 is credited with some points.
0
 
PaulyGilmourAuthor Commented:
Hank,

The 64 bit version of IE didn't work in either case. It didn't work with a 64 bit Office and 64 bit OS nor does the 64 bit IE work on the 32 bit Office and 64 bit OS. The only way it will work is to use the 32 bit IE and a 32 bit Office.

So using the same versions of IE and Office isn't quite true, it was only the 32 bit IE with the 32 bit Office which showed the filters, 64 bit all around didn't work.

I did give you points though after it was suggested... I'm quite the newby on this site so figuring out how to share points and points etiquete is all new to me so be gentle :)

Again though, thanks for leading me down the right path.

Paul
0
 
Jamie McAllister MVPArchitectCommented:
Paul,

Welcome to EE.

Thanks for revising your decision. As you will appreciate Experts on this site answer questions for the pleasure of helping others and for kudos. Points have no monetary value to Experts but are a mark of recognition for their contribution.

It is always good to award points when experts pitch in.

We're all happy to help in future.
0
 
HankinaterCommented:
Thanks Paul,

Apparently the 64-bit version of Office doesn't ship with the 32-bit versions of the ActiveX control that is used in datasheet view.  You can download the 2007 Office System Driver: Data Connectivity Components here:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

found the reference at Know SharePoint blog

Hope that helps!

Hank
0
 
PaulyGilmourAuthor Commented:
Thanks for the link... It's Office 2010 not 2007 but I did find a link for that version here:
http://www.microsoft.com/en-us/download/details.aspx?id=13255

I'll add it to the user's laptop and post back results. Ideally this would be better than putting the 32 bit version of Office on her laptop.

Paul
0
 
HankinaterCommented:
Yes, but notice the blog post is indicating they're talking about Office 2010 not having the components necessary.  I believe they mention Office 2007 Data Connectivity Components because they definitely have the 32-bit versions of the ActiveX controls you'll need.  

Hopefully the download you chose will have them as well.

Hank
0
 
PaulyGilmourAuthor Commented:
Tried w/ the 2010 link without success, then with 2007 link. 2007 link worked. Thanks Hank...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now