I've downloaded the California State University Final Budget Summary for last year from this website:
Most of the data is presented as a pivot table. I was curious to see the actual data that the pivot table is referencing. I looked at "Change PivotTable Data Source" and this is what's listed as the current source:
By my reading, there is another .xlsx file that is being referenced called "1516.Final.Budget.Blue.Book.xlsx".
So my questions:
- Is there a method for me to access the second .xlsx file directly?
- Did they release this data in this method to specifically keep people from accessing the second .xlsx file?
I'm not looking to "hack the system" or gain access to information that's not publicly available. I am just interested in how this link works and, if possible, looking at the data structure that the PivotTable is referencing.