excel 2007 problem

Faolchu

Guys

I have a small problem.

a user has two excel documents. they are using 2007 but I think the workbooks are 2003 files. Workbook A and B
Workbook B has links to cels in workbook A, these cells are usually totals using =sum( )

They have a column with an =sum( ) in workbook A, they insert a new row in the column in workbook A and the sumtotal updates to refelct the change (the formula for auto sum updates too obvioulsy)

however teh cell in workbook B doesnt update to reflect the change from workbook A.

now the user is claiming tht this has happened in the past. anyone any idea what the issue is?

Odaise Gaelach

I don't have Excel 2007 on my computer, but the autoupdated values seem to work all right in Excel 2010 using a 2003 file.

Try creating a new workbook that has a a column of data in Sheet 1, and a SUM cell in Sheet 2. Then add a new row in Sheet 1 and add some data into it. If the cell in Sheet 2 works then the issue might be within the workbook, or how the data's arranged.

Faolchu

i honeslty think it is related to the workbooks being 2003 and some form of compatability issue.

I'm gonna try create two workbooks that are 2007 format and see if i get the same issue.

Faolchu

ok tried just creating 2 blank spreadsheets and kept them in 2007 format and it wored fine. I then did a save as and xselected 2003 format and then inserted a row and it too was fine.

so i think its teh actual docs. Gonna make copies of them and convert them to 2007 format and see will it help any.

Faolchu

nope not the docs, i made copies and placed them on my hard drive, made changes and it updated automatically even if only one doc is opened.