Posts tagged Excel

Office 365 integration with the Office desktop apps appear to be quite useful and impressive, however, there are still some problems with it. One flaw we found was with the compatibility between web and desktop apps. I found my self rather annoyed that after creating a mock payrole Excel spreadsheet and uploading it to SharePoint Online, it could not be viewed on the 365 website, this was because the desktop appwas not fully compatible with the web app. There are certain features that the desktop app has which the web app cannot use, in the spreadsheet that I created I used validation fields in some cells, this feature was not supported int eh web app there for not accessible on 365. Granted the file can still be opened from the Cloud on the desktop app but the user might not always have Microsoft Excel installed on their machine. Although not fully explored this is true for other Office desktop features. I find this to be a huge flaw in Office 365 and I would hope that this is sorted out for the release version.

RE

My first update, so far I have mostly been looking at both Web & Desktop app features with Office 365.

Not a lot of noise has been made about being able to upload Access Databases into Office 365 SharePoint Online as of yet, most of the focus has been drawn to the simpler applications such as Word and Excel. I find this to be quite a useful feature in Office 365. Access database forms are ideal for 365, they are best used for browsing records in database and also adding,
deleting and editing. For example a user can create a web database on Access 2010, create tables, forms, queries and reports. Once this is done, they simply go into options, set the page to automatically display a form or report (or whatever) once opened then go to file->Save & Publish, go to ‘Publish to Access Services’ and type in the URL or the site and a new folder name for it and click publish. I published a mock database onto the ADP site at http://adp.sharepoint.com/TeamSite/ADP%20Data/ which appeared almost instantaneously, I could then browse records in a form that I had produced.

I found this to be an incredibly quick and easy proccess with little effort or even knowledge required. Once displayed on the website it appeared to very visually appealing, looking exactly the same as it it did in Access.

The same can be done similarly with Word documents and Excel spreadsheets. However for this Microsoft Sharepoint Workspace needs to be set up properly with Office 365 sharepoint online. Once this is configured properly the user can click save as, click the word/excel button, select wich workspace to upload to then select the subfolder they wish to display the document and click save, the document willt hen be on 365 Team Site or wherever the user chose to upload.

RE

Office Web Apps is a great way to access your documents from  almost anywhere on almost any device. It also provides a brilliant tool for groups of people to view and edit documents at the same time, removing the need to email back and forth multiple versions of an Excel spreadsheet for example. Everyone can see the most up to date version regardless of their location.  The link below contains a video to show how easy it is to use Office Web Apps on the go.

http://www.microsoft.com/office/RM/ExcelWebApp.aspx?WT.mc_id=AO_enus_eml_excelwebapp

The remote access capabilities that SharePoint Server 2010 and Office Web Apps provide are also of great benefit within educational institutions. From the case study (link below) Herrity says, “Students can connect to resources instantly and easily. Office Web Apps help students accomplish more. They can access applications through the browser, without needing software installed on their home machines. This removes many socio-economic issues.” Now, it does not matter whether students have the latest version of Microsoft Office installed on their home computers. Through the learning gateway, students can quickly and easily make changes within the browser based Office Web Apps, which are covered by the school’s licensing.

http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000007260