G
Guest
I have a spreadsheet which uses the subtotal function in several rows to give
me sutotals for groups within groups which can then be filtered by column
headings. I have then grouped and outlined the spreadsheet .
This all worked perfectly but suddenly the subtotals are only working when
all the groups are expanded, when closed the subtotals show as zero. I have
a back up copy from the previous week which is still working fine and the
only difference I can see between the two copies is the fact that most of the
row numbers in the faulty copy are shown in blue then revert to black whereas
the back up copy row numbers are all shown in black.
I have tried ungrouping and starting again but it doesn't make any
difference. Does anyone have any clues what's happened and what is the
significance of the blue row numbers??
Thanks
me sutotals for groups within groups which can then be filtered by column
headings. I have then grouped and outlined the spreadsheet .
This all worked perfectly but suddenly the subtotals are only working when
all the groups are expanded, when closed the subtotals show as zero. I have
a back up copy from the previous week which is still working fine and the
only difference I can see between the two copies is the fact that most of the
row numbers in the faulty copy are shown in blue then revert to black whereas
the back up copy row numbers are all shown in black.
I have tried ungrouping and starting again but it doesn't make any
difference. Does anyone have any clues what's happened and what is the
significance of the blue row numbers??
Thanks