skip to Main Content

Cross-Sheet Hyperlinks Part Two

 
Power Pivot Scorecard Mockup With Clickable KPI Metrics

Scorecard with Clickable “Key Performance Indicator” Metrics
(Yes, the colors are awful, sorry – I lack that touch)

Not Just for Sheet Navigation, But Also for “Drilldown”

Picking up from Tuesday’s post

When you click that “Customer Behavior” metric in the image above, you are taken to this detail page:

Detail Drilldown Report - Just a Pivot Designed by Me On Another Sheet

The single “19%” Number in the Scorecard “Expands” to this Full Detail on Click!
(Also note the “Back to Scorecard” Link)

That Was a Cube Formula Cell!

Read the Rest

Pro Tips: Cross-Sheet Hyperlinking Part 1

                            image

Hyperlinks Are a MUCH Better than Making the User Find the Right Sheet Tab         

Sorry About Last Week Smile

Yeah, we were a bit “light” on new material here on the blog last week.  That happens when I have four straight days of presentations out of town (more on PASS BACON later).

Inspired by Kasper’s Book!

I was reading Kasper’s new book on the plane (yes, I was home less than 24 hours, and am now back on the road), and its singular focus on building a full-featured set of dashboards inspired me.

It is clearly time for a mega-post on hyperlinks!

First Usage:  a Menu Sheet

As pictured at the top of this post, hyperlinks are a great way to construct a “menu” sheet.

Not only is this a BIG convenience for the “consumers” of your workbooks, but it makes the whole thing “feel” much better too.  More professional, more like an application and less like a spreadsheet.

Yes, hyperlinks can link to other locations in the workbook!  It’s easy in the Insert Hyperlink dialog:

Read the Rest