2 of 2 people found this helpful
I agree with everything Shawn said, but you can draw this out on paper to see the problem.
Without using Server, your choices are :
A) 1 workbook, 8 datasources (extracts maybe ?) and change the connection and "Save as" every time the data changes and you need to redistribute.
B) 8 workbooks, 1 (or 8) datasources and make the same dashboard change 8 times over ... assuming every change needs to be done in every dashboard.
With Server you can have
C) 1 workbook, 1 datasource, each user logs in with their own username and only sees their data.
FWIW, A is probably the best without using Server, but you will be massively more productive by using Server and going with C
1 of 1 people found this helpful
That's exactly what I thought. Well, I guess I will just have to make individual ones and email them to each director. I'm all for going with the server, but that literally would take years (I'm on a workgroup for it) and the state moves at a snail's pace, PLUS it is all about cost. Oh well! :-)