Poorman Excel Services: Excel query files

The Steps If you don’t have SharePoint Excel Services and want to do more charting, pivots, or heavy excel-related functions than WSS or MOSS Standard allows, try “Exporting to Spreadsheet” from a list.  It works well since the data can more easily be maintained in a SharePoint list but shared and presented in Excel.  What I’ve outlined below, really just leverages the Excel query functionality.  This works with all versions of Excel...

Read More

SharePoint 2010 Failover Database: How am I going to use that?

After reading Mike Watson and Todd Klint's take on SQL Mirroring in SharePoint 2010 and the new Failover Database Server option, it got me thinking how I would do disaster recovery in our environment.  SharePoint used to just be for collaboration but now is a critical part of daily operations (ie storing DR process docs), incident response workflows, and the list goes on. With this new functionality and the DR options of visualization platforms,...

Read More

Step by Step: Adding Search Box to a SharePoint page

Normal 0 false false false EN-US X-NONE X-NONE ...

Read More

MSFT's Prod Hub 2010 released

For those moving to Microsoft Office 2010 products and you have a SharePoint environment, the Productivity Hub 2010 could be a helpful tool in your migration plan. It was release on June 28th but expect additional content to be added as more upgrade to 2010 products.  It doesn't replace the PR campaigns, communications and help desk scripts but gives end-users a good place to go internally for some extra documentation as well as videos. The...

Read More

Don't email me an Excel Spreadsheet

To often people send me an email with an excel document attached. Then ask to update it, I send it back, and then they look for additional edits and before you know it there are multiple versions floating around.  I'm sure this has happened to you. While it isn't the answer for every spreadsheet, in most case I just want to tell them to put it in SharePoint and create a list! Import Spreadsheet option: An often overlooked perk of SharePoint...

Read More