Category Archives: Microsoft Office

Outlook 2010 sync “SharePoint List cannot be found.”

Reference: http://mikessharepoint.wordpress.com/2011/04/18/outlook-2010-sync-sharepoint-list-cannot-be-found/ Ran into a funny problem today and decided to blog about it, since I spent so much time with it. A user came to me today saying he couldn’t get the “Connect to Outlook” sync working with a … Continue reading

Posted in Outlook, SharePoint 2010 | Leave a comment

WORD, EXCEL file from SharePoint is opened very slowly

Go to IE >> Internet Options >> Connections >> LAN Settings: Then uncheck the box for “Automatically detect settings” This will make opening WORD and EXCEL file faster.

Posted in Microsoft Office, SharePoint 2010 | Leave a comment

Update Single/Multiple Lookup field in SharePoint 2010 using WCF Data Services, REST API, C#

If you want to use SharePoint 2010 WCF Data Services to update SharePoint lookup field in a list; you need remember following things: To update single Lookup field: Use Id to reference to the looked up list object to the … Continue reading

Posted in Outlook, SharePoint 2010, Visual Studio 2010 | Leave a comment

Access and SharePoint 2010 Integration

Option 1: Save the Access file into a SharePoint document library and share with others; Option 2: Create lists and document libraries in SharePoint; Go to “Datasheet View”, open the task pane on the right, “Track this list in Access”; … Continue reading

Posted in Access, Microsoft Office, SharePoint 2010 | Leave a comment

Examples of commonly used Excel formulas

http://office.microsoft.com/en-us/excel-help/examples-of-commonly-used-formulas-HP005200127.aspx  

Posted in Excel, Microsoft Office | Leave a comment

Excel Magic Trick: Date Functions & Formulas

Posted in Excel, Microsoft Office | Leave a comment

Link an Excel workbook to a SharePoint list

http://www.youtube.com/watch?v=weyli9OGJhk You can export a SharePoint list to an Excel workbook and do data analysis on Excel. When data in SharePoint list is changed, it will change the Excel workbook as well, so you will always have an up-to-date Excel … Continue reading

Posted in Excel, Microsoft Office, SharePoint 2010 | Tagged , | Leave a comment