Secret Timesheet URL Viewer

This one is short and sweet. I noticed that when I view my timesheet in Project, it has an associated Unique ID. This made me wonder if an admin could view any timesheet for any user, as long as they had the UID number. The short answer is YES! The second question was, is it … Continue reading

Easy-Peasy Cross-Project Links Report

Ok, dear readers, it really has been a LONG time. I have a huge queue of posts to write but I got behind and, well, there you have it. But I’m back now! I’m going to start with this easy little gem – a query to show what projects are using other project tasks as … Continue reading

Actually “Unpivot” a Pivot Table

When I first started working with Pivot Tables, especially those generated from an external data connection, I remember doing constant google searches that looked something like this: unpivot pivot table excel 2010 remove pivot table excel 2010 Remove pivot table data connection keep pivot data Depivotize a pivot table Why are pivot tables complete jerks … Continue reading

Filter Pivot Table by Cell Format

This can actually be done, if you have the right data in your table. The trick is to create a pivot table in a tabular view with no more than one value column, if at all possible. If you can do that, you should be golden to embark on the magnificent task of being able … Continue reading