Sum in different sheet in Excel 2013

[emily1989]

Hi all,

Hopefully there is an easy fix for this! I 'upgraded' to Excel 2013 today and I have noticed that when I am doing a SUM or SUMIF etc in one sheet or workbook where the array is in a different tab or workbook, Excel no longer highlights the cells I am selecting, so it is relatively difficult to see which cells I have selected. Does anybody know a way to restore this functionality?

Thanks!

Emily

 

[XLfriend777]

Hi emily1989 - As nobody has responded I thought I would try to move this question along. Are you sure that the difference is in 2013? I don't have 2013, but I'm surprised they would change the functionality. If you can confirm that it is a 2013 issue, maybe someone with 2013 can help. Hope this move the thread along.

 

[emily1989]

Hi emily1989 - As nobody has responded I thought I would try to move this question along. Are you sure that the difference is in 2013? I don't have 2013, but I'm surprised they would change the functionality. If you can confirm that it is a 2013 issue, maybe someone with 2013 can help. Hope this move the thread along.

Hi, thanks for your response - it has definitely only started happening since I got 2013. Thanks!

 

[XLfriend777]

Hi em - That is such a pain when a version seems to remove features. I can't find anything else on the web about it, but I did find this Office 2013: the real startup guide link to a 2013 guide. I don't know if that has the answer, but it may be helpful with the new version. Sorry I couldn't help more.