Refreshing a protected worksheet

Hi everyone,

I have this workbook to keep track of current and new work for the team – each individual inputs information on their own tab.

In turn, the current information is displayed on a summary page so we can all see who's doing what.

I want to protect that summary page and its formulas from accidental amendment.

However, while the summary page (when unprotected) updates as soon as someone enters new information on their own tab, the summary page won't update when I have it protected.

Is there any way of doing this – preferably without VBA as it's a work situation and the employer doesn't like VBA code running?

Thanks,

Tim

Hi,

Thanks for your message.

I've realised that my question wasn't complete – sorry.

The problem occurs when the summary page is filtered as well as being protected. I've managed to be able to select the filter, even though the page is protected, and I guess the easy answer is to unfilter it and then filter it again – in which case the new entries made on the other tabs show up.

But, is there some way for those entries (that meet the criteria for the filter) to show up as they are entered?

Tim

Hi,

I reckon there’s something I’m doing wrong. Each time you send me something that shows that what I’m experiencing shouldn’t happen!

I’ve attached a draft excel spreadsheet - Workflow draft 20130106-Excelforum.xlsx

The concept is that—
* Each operator (there’s more than 1 but I’ve only done one tab while I get the spreadsheet sorted) enters information on their own tab, and (later) the date when it is completed. There’s 200 lines for that work – that should be sufficient for 12 months’ worth of work.
* As each team member enters it on their own tab, it should automatically turn up on the team tab.
* The team tab can be configured (I’ve used filtering) for our daily meetings so that only the ones that aren’t complete will be visible on the tab – so we can all see who’s got what current and if they’re overloaded & need a hand.
* If I unfilter the team tab, I’ve got the current period’s workload – current & completed – for workflow statistics and also to see how far overdue the completed work was.

How it works (or doesn’t)—
* As you’ll see there’s an amount of automated copying from the individual tabs to the team tab.
* Each team member will get 200 lines on the summary page but, by filtering the outstanding matters only in column H to the word “current”, we will be able to cut out blank lines & completed matters so we just see the current team’s work on one page. There’s probably a more elegant solution, I just don’t know it.

The problem I’ve found is that when I enter a new matter on the operators tab and the team tab is filtered, it doesn’t appear on the team tab unless I unfilter, then refilter.

Hope this makes it clearer – and thanks for your work.