How To Determine If A User Is Running 32-bit or 64-bit Office 2010
by on Dec.08, 2010, under Uncategorized
The two primary methods for determining if a user is running the 32-bit version or 64-bit version of Office 2010 is by checking the application itself or by checking the registry.
Method 1: Open any Office 2010 application and go to File–>Help
Method 2: Check the registry via Start–>type Regedit
- Registry path: HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\Outlook
- Registry key: Bitness
- Value: either x86 or x64
You cannot view a list in Datasheet View after you install the 64-bit version of Office 2010
by on Dec.08, 2010, under SharePoint Troubleshooting
You may have seen the following screen when attempting to view a list in Datasheet View with Office 2007 installed:
The fix for this was to enable certain ActiveX security settings and to verify that the Windows SharePoint Service Support options were properly installed with Office 2007. See the following blog posting for more info: http://blog.sharepointhosting.com/Lists/Posts/Post.aspx?ID=81
When experiencing issues with DataSheet View with Office 2010, you may see the following error:
If you are running the 64-bit version of Office 2010, you must install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available from the Microsoft download center:
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
If you are running the 32-bit version of Office 2010, please refer to the first blog posting linked in this post to confirm ActiveX and SharePoint Support options are properly installed.
Sandbox Solution Activate Button Disabled in SharePoint 2010
by on Oct.11, 2010, under SharePoint Configuration, SharePoint Troubleshooting
When attempting to activate an uploaded sandbox solution in SharePoint 2010, you may see the following dialogue box:
Resolution: Go into Central Administration–>System Settings–>Manage Services on Server and start “Microsoft SharePoint Foundation Sandboxed Code Service”:
“The specified file is not a valid spreadsheet or contains no data to import” Error When Importing an Excel Spreadsheet
by on Sep.29, 2010, under SharePoint Troubleshooting
When attempting to create a new list from a spreadsheet you may run into the error:
“The specified file is not a valid spreadsheet or contains no data to import”
Here is the solution:
• In Internet Explorer click Tools –> Internet Options.
• Click Security –> highlight Trusted Sites –> click Sites –> add your SharePoint site name.
Converting a Web Application to Claims-Based Authentication with SharePoint 2010
by on Aug.30, 2010, under PowerShell, SharePoint Configuration
If you already have an existing web application in Classic Mode Authentication and need to convert it to Claims-Based Authentication, you can only do so in PowerShell. The option is not available in Central Administration. The following PowerShell command will complete the conversion:
$convertApp = Get-SPWebApplication "http://sharepointwebapp" $convertApp.UseClaimsAuthentication = "true" $convertApp.Update()
