Auto Sum Problem

tsmalz

New Member
Joined
Jul 29, 2007
Messages
1
I have a simple spreadsheet with 4 different columns with numbers that I need to change frequently. When I change these numbers the totals at the bottom - at apprx line 95 - does not change. I have tried everything. I have to do it manually. Gets old. What am I doing wrong? Very simple use of Excel but I cant seem to find what the problem is. Never happened before. Help!

Thx
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Hi welcome to the board!

Can you post the formulas you are using with some more details on what happens on your worksheet so we can try to figure out why line 95 doesnt change?
 

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
A couple of possibilities:
Check tools/options/calculation and set it to automatic.

Failing that, in the unfortunate possibility that you have a "corrupt workbook" go edit/move and go to a new workbook, and see if it works then.

Finally, do you know if there is any VBA code in action here?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,161
Messages
5,768,542
Members
425,480
Latest member
br400821

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