It's Cloudy in Here

Search This Blog

on June 29, 2010

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

SharePoint Error: To open this workbook your computer must have a version of Microsoft Excel

Recently, I was working with a user who experienced this error message when working with an Excel file in SharePoint: To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser. The week earlier, I had encountered a similar error on my own computer as well. First, I wanted to check to see if the SharePoint Foundation Support for Office was installed (on my computer issue, this was not installed): I clicked on the Windows icon (or the old Start button location) in the lower left hand corner of the screen, select Programs and Features. The list of installed programs is displayed, scroll down to Microsoft Office Professional Plus 2010, left click on it once and on the menu bar select Change. Select the Add or Remove Features and then click Continue. Scroll down and expand Office Tools. Ensure that Microsoft SharePoint Foundation Support is installed...

PrePopulate SharePoint List Form Data (On Line Version) - Part 1

One recent project had a requirement where when a new list item was created, several pieces of information needed to be populated based on the logged in user (this is for SharePoint Online in Office 365). There are several great articles dealing with this utilizing InfoPath (credit here to Laura Rogers at http://www.wonderlaura.com ). However there is a way to accomplish this without having to create an InfoPath Library and just using a SharePoint list (my approach is to stay simple until I absolutely have to make things more complex). The first thing to create is the source list. Meaning the list that ties the user account to the data I wish to prepopulate in my list. Create a SharePoint Custom list (in my example titled: Source List) with the following columns: Department column (single line of text), and then a Users column which is a Person or Group column. (Please note for the Show field option at the bottom of the Person or Group column, select Account...

Common SharePoint Issues - DataSheet View Not Working

Due to a series of SharePoint migrations, I have been out of the blogging world recently. These have completed and I plan on being able to actively participate in the Office 365 Community again. In my role, I have the opportunity to work with companies of all sizes ( from small business to enterprise). There are some common issues that I have come across no matter the organization size, so I thought I would begin documentint some of these "common" issues. Issue : DataSheet view tab not working (greyed out): The users in this case are using Internet Explorer as the web browser of choice. Note: Internet Explorer is the recommended web browser. Not that Google Chrome or Firefox cannot be used but for all features to work properly, Internet Explorer is recommended. Troubleshooting : Have the user check which version of Internet Explorer is being utilized to see if it is 64 bit. In the version of Internet Explorer I am utilizing, there is an options ...

Powered by Blogger