Current Events > Work rant

(+) Yeah! (+)

There's new weekly reporting we have to do, and when I say "we", that's about 200 people. The report comes out Monday and is due Tuesday. What we need to complete this report is data from A, B and C. The first week was fine. The 2nd week, they took out a tab in Excel that had the data we needed, or so I thought. The tab was just hidden, but they didn't tell anyone that. Unhide the tab, good to go. That worked for 2 weeks, but now this week, the tab really is gone. Not hidden, just removed. As you recall, we need A, B and C to complete this report. One tab has A and B. Another tab has A and C. Because of what the A data is, a VLOOKUP wouldn't work in this scenario.

I questioned my boss about why they took the data tab out, and the response he got was it was removed "to protect the data integrity of the template". Their solution is to have the end user (remember, 200 of us) to try and figure out their proprietary pivot tables to pull the extra data we need. I know a little about pivot tables, but not the way they're doing them. They have little windows that clearly reference the pivot table (they call them "slicers"), but the pivot table itself is nowhere to be found. I'm probably ignorant, but I see no way to create a new slicer without an original pivot table to pick it from. I'm sure I'm not alone on this since there was no training.

Why are companies like this? Or maybe not all are, and I just work for jerks?

Did you try turning it up to 11?