hide sheets use data

[Guest]

I've made a main sheet that pulls data from the other sheets. If I hide the
other sheets with the data, my data isnt pulled from the other sheets. Is
there a way, wihtout vb, to make the other sheets hidden but still usable?

 

[Richard Buttrey]

I've made a main sheet that pulls data from the other sheets. If I hide the
other sheets with the data, my data isnt pulled from the other sheets. Is
there a way, wihtout vb, to make the other sheets hidden but still usable?

How does it 'pull the data' from the other sheets?

That rather suggests that you're running a macro since I can see no
reason why a formula which refers to cells on a hidden sheet wouldn't
work.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[damorrison]

How is it not working, I think you may have a protection problem, but
cannot determin if we don't know how the formula doesn't work

 

[gotigs88]

Are you hiding using Format->Sheet->Hide? It should still be usable.