Excel totals disappear

Question

I work with 2 monitors with 2 spreadsheets. When I add column on "A" spreadsheet I lose the total when I click on "B" spreadsheet. The sums are large and difficult to remember. I am using Microsoft Office Professional Plus 2016 on my job. How can I get the totals to remain on "A" spreadsheet while I enter them on "B" Spreadsheet? This was not a problem on one of the older versions

Thanks

Answer 1

Open the spreadsheet "B" in a new instance of Excel. Run "excel.exe -x" (without quotes). Now when you switch between the two windows, the sums should still be visible.

Answer 2

Hello Matilda,

We need to gather additional information to have a better view of this concern. Can you send us a screenshot of the issue you are experiencing in Excel? The instructions on how to insert screenshots in your post are posted in this link. Note: Please do not include any personal information.

For now, let us perform an online repair via Control Panel. Doing so will fix any issues you are experiencing when using any of your Office apps. The instructions on how to do so are posted in this article.

Please post back with the result for further assistance.

Answer 3

When I add up my totals on spreadsheet on right (B) and click on spreadsheet on left (A) the sum (see 2nd picture red circle at bottom of page) disappears. I need the sum total to remain on spreadsheet B when I am trying to enter information on spreadsheet A. This was not a problem with previous versions of Excel.

Answer 4

I also have a 2nd problem and I'm not sure if it is related. Sometimes when I click on a cell it will not highlight which cell is active. If there is information in the cell I can see the information in the formula bar but no highlighting around the cell. After a while it will start showing the active cell again.

Thanks

Matilda

Answer 5

Thank you for getting back to us and for providing additional information, Matilda.

Based on the screenshot that you provided, this concern is actually by design. When you get the total sum from workbook B and select workbook A, the total sum will definitely disappear since the active workbook will be the workbook A (which you select). However, when you go back to workbook B, the total sum should display. For this reason, we encourage that you post a suggestion or feedback to our Excel UserVoice. In this way, our engineers and developers will be able to look further into this concern and might do some changes in the future. This will not only help other users with the same concern, but will also help us in improving our products and services.

As for your second concern, it is possible that there's a corrupted Office component. That being said, we advise starting your Excel in Safe Mode. Doing so will help us identify if there are add-ins that are causing this concern. If the issue is not present in Safe Mode, we advise enabling each add-in to identify which causing this problem. However, if the issue is visible even in Safe Mode, we will repair your Office via Control Panel. Repairing your Office will fix any issues you are experiencing when using any of your Office apps. Here's the link where you can find the instructions on how to do so.

Feel free to get back to us should you need further assistance.