At first glance this doesnt look possible OOTB but it is, just not very obvious!

The way to achieve this is to:

1) Create a list at say Site Collection level which contains a column with the data in you want to use on another site.

2) Now create a Lookup column at Site Collection Level which is pointing to the data from the above list that you want to use.

3) Now you can add that column, to any list, on any site, throughout the site collection.

More From pstilgoe

• Enable anonymous access on a Sharepoint site
• How to easily move / copy list items from one sharepoint list to another
• Change default.aspx to a different page with different name

Ask pstilgoe To Recommend Your Posts

From the Desk of the CEO at Bamboo Solutions: An Optimistic View for 2009 and Beyond!

Optimism? It would be a bit indulgent for me to write a year-end blog in 2008 without at least acknowledging that the economy is in a mess and we are living in uncertain, if not really uncomfortable times. I know that in part because I receive about fifteen emails each week from various service providers who each promise to educate me about how to “survive difficult times.” Trillions of dollars of deficits, billion dollar losses, foreclosures and bailouts dominate the news, along with inevitable comparisons to the Great Depression. The news feels like the History Channel, filled with stories about asteroids hitting the earth, Mega-Disasters, Nostradamus and projections of various types of doom.

I’m not buying it. Actually, I am just incredibly optimistic about the future – for SharePoint, for IT in general, for your company and for Bamboo Solutions in 2009 and beyond. So I’d like to take this opportunity at the end of 2008 to reflect a bit, give you some contrarian views based upon what we here at Bamboo see happening within our customer base, and then share a bit with you about how we plan to continue trying to help in 2009 and beyond.

So why am I optimistic?

First, IT analysts that we track say that growth in IT spending will be down in early 2009, and pick up at end of year. But wait! Read that sentence again. Growth will be down a bit, and then pick up. Unlike the days of the dot-com crash, perceived excesses in technology spending have long been wrung out of much of the IT budget. Information Technology projects are now more often viewed as real enablers of doing more with less. So while IT is certainly not recession-proof, much of IT spending is much less discretionary than it was 10 years ago.

Second, underserved demand for business collaboration remains huge. In the past decade, the notion of using Web-based information sharing and collaborative applications both within and across companies has been a key vision for a lot of companies. Portals, shared content, collaborative and composited business applications remain part of that vision. But many companies, especially mid-size companies, have still been hesitant to broadly deploy until a clear technology emerged as the de facto standard. With respect to our friends at Oracle and IBM, I believe Microsoft’s SharePoint has, or is certainly becoming that platform, with tens of millions of licenses shipped, and with MOSS 2007 emerging as the fastest growing product in Microsoft’s entire history. If you are a company with a mixed investment into IBM, Oracle and Microsoft technology, you may argue relative technical pros and cons. But the plain fact is that the marketplace is voting for SharePoint with its wallet. That means the economics of scale will only drive further innovation and more adoption, which in turn means lower overall cost, which will again increase adoption. So the way I see it, pent-up demand is only just now starting to be fulfilled as the risks of implementing continue to go down.

Third, based on what I hear from our customers, I’m convinced that SharePoint is just starting to deliver on its potential. Bamboo Solutions may be small and scrappy as compared with behemoths like Microsoft, but between our storefront and Bamboo NationTM we now touch tens of thousands of individuals every month. Over 4500 companies and 110 partners across 38 countries around the world use our products. From this perspective, I think we can claim at least a pretty good read on what is happening. And what I hear is this: The vast majority of our customers are in the early stages of deployment; three quarters say that the SharePoint will be deployed enterprise-wide; and, the overwhelming majority plan to do even more with SharePoint in 2009.

As for the recession, I read the newspapers too. There’s plenty of downsizing and budget cuts in almost all parts of the economy, and even in the high-flying tech sector, companies like Google, Yahoo, Cisco, HP and scores of others have shed staff. But remember that recessions are only defined in retrospect. So when the doom and gloom news seems the worst, that’s precisely when things are probably rebounding. What we hear from our customers is that within companies today, and relative to other IT spending, solutions built around SharePoint seem are getting relative high priority. As a result, technical design and development talent around SharePoint remains very scarce. Individuals who possess technical knowledge of SharePoint along with with knowledge of business requirements are in very high demand.

Read the full article here

More From pstilgoe

• Import data from CSV and SQL to a SharePoint list
• Allowed anonymous access on a Sharepoint list and still get prompted for a login
• Creating a scheduled email reminder using Sharepoint Designer

Ask pstilgoe To Recommend Your Posts

When you try to activate ‘Office SharePoint Server Enterprise Site Features’ you get the following error:

Office SharePoint Server Enterprise Site Collection features12/09/2008 16:00:51.91
w3wp.exe (0x1FB8) 0x17B8 Windows SharePoint Services
General 8grz High The feature
’8581a8a7-cf16-4770-ac54-260265ddb0b2′ depends on feature
’43f41342-1a37-4372-8ca0-b44d881e4434′ which failed to activate:
Microsoft.SharePoint.SPException: A duplicate name “Report” was found.

The problem occurs if you have created a custom content type called ‘Report’ this is because when you activate ‘Office SharePoint Server Enterprise Site Features’ it trys to create a system content type called ‘Report’. The workaround is to rename your custom content type from ‘Report’ to something similar.

More From pstilgoe

• Enable anonymous access on a Sharepoint site
• Displaying the week number using a Sharepoint calculated column
• Sharepoint: Group a list by month

Ask pstilgoe To Recommend Your Posts

Rollup content in multiple site collections

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• How to Prevent users from changing views in Sharepoint
• How to delete the Shared Service Provider in MOSS 2007

Ask pstilgoe To Recommend Your Posts

For the Users:

Dedicated Recycle bins
Dedicated usage Reports
Distributed administration (site collection administrators)
Dedicated search scopes, keywords, and best-bets
Custom feature deployments
Dedicated language translation maintenance
Dedicated galleries for web parts, master pages, content types, site columns, site templates, and list templates
Dedicated shared libraries, such as site collection images and site collection styles
Dedicated real estate (Self Containment)

For the IT Administrators:
Site quota templates
Distributed administration
Site locking
Database maintenance options
Backup / Restore abilities
Content Deployments
InfoPath forms services global template targeting

Source: Site collection logical architecture

More From pstilgoe

• Enable anonymous access on a Sharepoint site
• Displaying the week number using a Sharepoint calculated column
• How to Rollup Content from multiple Site Collections

Ask pstilgoe To Recommend Your Posts