I used to work for an actuarial team that thought very highly of PivotTables.
And I mean very highly.
I took a data set and created one Excel workbook with something like 20-30 PivotTables spread throughout 5-10 worksheets.
Occasionally, I'd be informed that there's an error with how the data were pulled, because the code was written in a programming language that, even if you were to Google it, you wouldn't find much help. Then I'd have to reload the data set and reconfigure every one of the PivotTables.
Also, the PivotTables didn't quite match what they wanted, so inside said worksheets, I had "formatted" versions of the PivotTables as well (which were just duplications of said PivotTables to the right of the PivotTables + some merging of cells). AFAIK there's not a VBA solution for this.
Another data set that I was asked to analyze exceeded the row limit in Excel, and required the same PivotTable business. Therefore, I had to learn PowerPivot. One of the things I figured out very quickly is that once you import data into PowerPivot, your data is stuck. If you have to change it due to errors in the data (which did happen quite a bit), you have to delete your old data set in PowerPivot and reconfigure (maybe even recreate! It's been too long) all of the PivotTables you created.
...I tried googling on this, but wasn't happy with the result... got examples of these questions?
Psychologist's [Psychiatrist's?] name Carl Rogers, I believe. The key question for me was (well, duh) "How do you feel about that?"
Which one of those two do you have?? Usernames or passwords?
A sales person sent me membership information about a group in excel. Apparently they already had it in excel, so they simply took a screenshot, and pasted that picture in a new workbook. Then they sent me the workbook containing a picture of their workbook, with it perfectly sized so it lined up with the rows and columns at the edges of the picture. I was confused as to why it wasn't letting me select the data until I figured out what they did.
Didn't trust? Or didn't know how?
My semi-retired aunt, who does interior decorating part-time, uses spreadsheets like that because she doesn't know how to use formulas. The spreadsheets are really just for neatly formatting numbers and corresponding text into rows and columns before printing them (without gridlines) and giving them to clients for estimates or billing.
Last edited by Sredni Vashtar; 10-21-2017 at 01:25 PM..
That's really clever in a way.