And lo On Wed, 16 Feb 2011 17:38:47 -0000, Darren New <dne### [at] sanrrcom>  
did spake thusly:

> Phil Cook v2 wrote:
>> But the advantage of the pivot table
>
> OK. I'm not familiar with the details of how pivot tables work. Thanks!

I don't think many do, which is a shame. I'd bet a lot of duplication of  
data occurs because of this. Well worth playing with them

>> Yes it's a common technique to put 'workings out' on another sheet and  
>> then hide it; the formula is "=SheetName!Cell"
>
> Cool. Thanks!

Nada. If you really want the sheet to be hidden rather than use the  
toolbar a quick bit of VBA will stop it showing to causal users who  
understand the Hide|Unhide command - Sheets("SheetName").Visible =  
xlVeryHidden attached to the Workbook then password protect the module.

-- 
Phil Cook

--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com

Post a reply to this message