| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hide sheets use data
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? |
|
#2
|
|||
|
|||
|
hide sheets use data
On Wed, 2 Nov 2005 13:28:01 -0800, j2thea
wrote: 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 __________________________ |
|
#3
|
|||
|
|||
|
hide sheets use data
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 |
|
#4
|
|||
|
|||
|
hide sheets use data
Are you hiding using Format-Sheet-Hide? It should still be usable. -- gotigs88 ------------------------------------------------------------------------ gotigs88's Profile: http://www.excelforum.com/member.php...o&userid=28468 View this thread: http://www.excelforum.com/showthread...hreadid=481573 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from different sheets in one | New Users to Excel | |||
| transfer data in excel between sheets | Excel Discussion (Misc queries) | |||
| Chart sheets cause data sheets to be blank | Charts and Charting in Excel | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Linear Mode
