Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple sheets selected
I use a spreadsheet with multiple sheets (15 sheets). There are no links
between the sheets. I find that when I have all sheets selected, text or figures typed on one sheet can also appear on another. If I remove rows from one sheet , rows are removed from other sheets in an arbitrary manner. This happens only when all sheets are selected. I have checked the cells for links, there are none. Does anyone have an idea about the cause of this problem. Regards Tom Walsh |
#2
|
|||
|
|||
Hi
this is the normal behaviour of 'grouped' sheets. If you select all sheets this is just what should happen :-) -- Regards Frank Kabel Frankfurt, Germany twa14 wrote: I use a spreadsheet with multiple sheets (15 sheets). There are no links between the sheets. I find that when I have all sheets selected, text or figures typed on one sheet can also appear on another. If I remove rows from one sheet , rows are removed from other sheets in an arbitrary manner. This happens only when all sheets are selected. I have checked the cells for links, there are none. Does anyone have an idea about the cause of this problem. Regards Tom Walsh |
#3
|
|||
|
|||
You know the one about "when all else fails read the instructions". Right
after posting I tried out this behaviour on a blank sheet with 3 sheets selected and found out for myself what was going on. Apologies for the stupid question. Regards Tom Walsh "Frank Kabel" wrote: Hi this is the normal behaviour of 'grouped' sheets. If you select all sheets this is just what should happen :-) -- Regards Frank Kabel Frankfurt, Germany twa14 wrote: I use a spreadsheet with multiple sheets (15 sheets). There are no links between the sheets. I find that when I have all sheets selected, text or figures typed on one sheet can also appear on another. If I remove rows from one sheet , rows are removed from other sheets in an arbitrary manner. This happens only when all sheets are selected. I have checked the cells for links, there are none. Does anyone have an idea about the cause of this problem. Regards Tom Walsh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) |