Sum in different sheet in Excel 2013

emily1989

New Member
Joined
Jun 10, 2014
Messages
2
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
649
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

New Member
Joined
Jun 10, 2014
Messages
2
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!
 

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
649
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. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,892
Messages
5,598,702
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top