Excel-Wndows 7

[BJS]

I have 2 workbook pages. In one, when increasing the size of the table I am using, I have to adjust the TOTAL column manually to include the cells added in the new range, whereas in the second page, this is done automatically with no manual adjustment necessary. What do I need to do in the set up of the first page to achieve it operates automatically same as page 2. Thanks for any help.

[gen2]

I suspect you have the table set up differently in each sheet.

It depends on where you are inserting new columns in relation to the range being summed..If the new columns are inside the summed range, then the total formula will adjust accordingly. If outside the range, it wil not be included.

eg data in cols A,B,C,D. Col E left blank
Col F = SUM(A1:E1)
now click on col E heading and insert column. Formula will include it.

Another possibility is that you may be using = A1 + B1+ C1 + D1
Such formulae will never automatically include any added columns.

[BJS]

I have obviously not worded my question correctly. What I was trying to say was say the table has 6 columns with 20 lines down. If I increased the table to say 30 lines down in 1 page the 6 totals in the total line would update to include the extra 20 lines whilst in the other book, I had to manualy readjust the total in the 6 columns Does that make it more clearer another MAGIC (SENIOR) moment.

[SeaJayPea]

In Office 2003, there is the facility on the Tools menu to select Options, then Calculation. I'm guessing that whatever version of Office you're using has something similar. One of your workbooks will have the Automatic tab ticked, the other one may not. If that's the case, tick it and away you go.

Good luck

[BJS]

Again another MAGIC moment I should have said that my version is Excel 2010. I have checked and as far as I can see the Automatic function is enabled. I have opened a new Excel page and doing a 2 line sum, then increasing it by adding another cell but the sum does not include the figure in the new cell.
I have tried to compare the settings in the workpage that works OK against the one that does not but cannot see any obvious difference. I'm stumped.