Getting around the 5000 item limit threshold

Don't you hate it when you get the dreaded "This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator." message?

I do.

Well, sure you can break from best practices and increase the throttling limit (If, that is, you've got access to Central Admin. Which, I'm assuming, you don't.)

OR...

You can create a Datasheet view...

By default, it bypasses the threshold limit.

When doing so, start with only a few colums and add more later. It will speed things up a bit.

BTW- There's a very good reason for this, and other limits, when it comes to SharePoint views. You can read more about them here- http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx

HTH!