I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.

Erin

ToolsOptionsCalculation.

Are you set to "manual"?

Change to "automatic".


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 14:39:01 -0800, Erin <Erin @discussions.microsoft.com wrote:

I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.

I am set to "automatic", I have doubled and tripled checked that.
Thanks.

"Gord Dibben" wrote:

Erin

ToolsOptionsCalculation.

Are you set to "manual"?

Change to "automatic".


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 14:39:01 -0800, Erin <Erin @discussions.microsoft.com wrote:

I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.

Maybe resetting xl's calculation engine would help?

I'd try selecting all the sheets (so I only have to do this once).

Then select a single cell (so that all the cells are looked at in the next step)

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Then ungroup the sheets.

excel will see that you're changing formulas and reevaluate each of those
formulas--maybe it'll wake excel up???

Erin wrote:

I am set to "automatic", I have doubled and tripled checked that.
Thanks.

"Gord Dibben" wrote:

Erin

ToolsOptionsCalculation.

Are you set to "manual"?

Change to "automatic".


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 14:39:01 -0800, Erin <Erin @discussions.microsoft.com wrote:

I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.



--

Dave Peterson

Interesting approach.
Thank you for the idea, I will try it.

"Dave Peterson" wrote:

Maybe resetting xl's calculation engine would help?

I'd try selecting all the sheets (so I only have to do this once).

Then select a single cell (so that all the cells are looked at in the next step)

Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Then ungroup the sheets.

excel will see that you're changing formulas and reevaluate each of those
formulas--maybe it'll wake excel up???

Erin wrote:

I am set to "automatic", I have doubled and tripled checked that.
Thanks.

"Gord Dibben" wrote:

Erin

ToolsOptionsCalculation.

Are you set to "manual"?

Change to "automatic".


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 14:39:01 -0800, Erin <Erin @discussions.microsoft.com wrote:

I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.



--

Dave Peterson