All,
Dept 1 are downloading data into excel on the 1st of every month from an SQL db. This is their archive solution since the SQL database is always current and doesn't or can't hold historic data - just not been set up that way.
I've created an excel dashboard (excel 2010 workbook) using...
Thanks for that, it seems to work. Although the conditional formatting doesn't seem to extend across the row labels too.
If I change this apply this option to include the label row. I receive the following error: cannot apply a conditional format to a range that has cells outside of a...
All,
I have a pivot table which connects to external data and refreshes on opening. I can conditional format cells based on a value, yet how can I conditional format entire rows based on a cell value?
I want to actually hide the referencing column/cell value, but still somehow be able to...
All,
Struggling to figure this one out.
I have a pivot table with a column label which is a date field (assignment finish date). My values are a count of the assignement finished date. i.e. How many assignments were finished on day X?
I need to conditional format my value field counts to...
All,
Pretty new to dashboards. My dashboard is one pivot table, with various columns.
I know that if you expand on a value in my pivot table, it drills down and you can see what is behind the value on a separate worksheet.
Can you get the drill down to happen automatically?
I have a...
Luke M.
Thanks,
If I'm put into a group, because I'm already in that group, which other groups am I in as well?
If I start by selection my location i.e. London. Then I'd be shown a list of possible departments specific to that location.
i.e Tax,HR,Marketing.
Then if I select Marketing...
All,
Pretty new to Excel (2010). Yet, really enjoyed the brief training I've had. Now everything is - must be able to be done in excel.
I've data - "groups names", extracted from LDAP in an excel format. I'm thnking about a flow chart to show the top level and how by placing X in a certain...