J
John Smith
Hi there!
Am using excel 2002 SP3, whenever I used Sum or Autosum function in range,
it's still calculating and including my hidden rows & columns. Is there any
way, options, add-ins or settings that can help me eliminate and exclude
those hidden cells in my calculations? Any help will be greatly appreciated,
I've tried "save-as" to other formats (xls & dbf) and it's still showing,
custom views and advance filter doesn't seem to help either. Thanks in
advance guys...
Am using excel 2002 SP3, whenever I used Sum or Autosum function in range,
it's still calculating and including my hidden rows & columns. Is there any
way, options, add-ins or settings that can help me eliminate and exclude
those hidden cells in my calculations? Any help will be greatly appreciated,
I've tried "save-as" to other formats (xls & dbf) and it's still showing,
custom views and advance filter doesn't seem to help either. Thanks in
advance guys...