Pivot Tables break when an Excel spreadsheet is opened from a Sharepoint site

I posted an Excel spreadsheet to a document library in our Sharepoint 2003 site.  When I open it from there, all of the Pivot Table source data is ‘broken’.  Rather than using the named range ‘[rangename]’ that I had given when I set up the Pivot Table, it now points to https://[servername]/[sitename]/[filename]’![rangename] which it then…

Nifty Widgets

I’ve been trying out new (for me) Microsoft widgets on my laptop. In doing so, I’ve run across a few things that work well: Windows Live Toolbar – I’ve been a Google toolbar guy for years.  One of the main things I like about it is the Autofill capability.  Live Toolbar now has that with the…

Using the “Hot Zone” to Smooth Intranet Portal Creation

As we’re building up the infrastructure to support knowledge management and collaboration for our new company, we’re learning some valuable lessons about how to create our Intranet portal and populate it with the right, valuable content. This portal experience has been a bit surreal.  Because building these portals is what we do for our clients,…