i am using excel 2003 and i have a total sheet in my workbook that i have setup to do automatic updating using this formula: =SUM('[Client1]Client 1'!I37). my problem is that the cell is not updating automatically. i have to reisert the formula to get it work, is there something i can do to fix this?

also is there any code available that will allow me to change the tab names when a cell in the sheet is changed? in other words if someone adds a new client is there someway for the tab name to automatically change to that name? if so how can i do it?

thanks,
knottrodney

For the first part, check Tools > Options > Calculation and make sure it is set to automatic

For the second part, you can change the names of tab in code several ways. Each worksheet is a Sheet object and can be referenced using it's index or it's name. The desired property, as expected, is Name

As for the "automatically" part, you have to decide what the trigger is and where to put the code.

tc

------> Edit <------

Your formula is set to sum one cell, in a worksheet with brackets in it's name, which Excel 2003 does not allow. Rename your worksheet and try again.