hide sheets use data

J

j2thea

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?
 
R

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?
Click to expand...

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
__________________________
 
D

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
 
Top