Monthly Archives: September 2012

Working with large lists in SharePoint

SharePoint 2010 lists and libraries can hold a maximum number of 30,000,000 items. In a SharePoint site the list view threshold is 5000 for users and 20,000 for auditors and administrators. If the list has more than 5,000 items, even … Continue reading

Posted in SharePoint 2010 | 2 Comments

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

Highlight row color based on field values in Sharepoint 2010 list view

Option 1: Go to SharePoint Designer 2010 Go to your list, open the list view you want to modify in ribbon, select Options [Tab] – Conditional Formatting – Format Row option. Option 2 (i haven’t tested it yet!!): (http://saltypc.com/?p=99) Go … Continue reading

Posted in SharePoint 2010, SharePoint Designer 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

Excel 2007 – How to Create a Summary Report from an Excel Table

Posted in Excel, Microsoft Office | Leave a comment