I have office 2007. For some reason, in any workbook when i try to link to another worksheet within the workbook all my grouped rows and columns become expanded. This is probably in my settings but i don't know where. If i make a sum formula from sheet 1 using a sheet 2 value then when i click sheet 2 all rows and column groups become expanded.

Help! Thank you