I am working in Excel 2007, although I don't think the problem is specific to
this. I have a workbook with about a 100 worksheets and 10's of thousands of
formulas. Basically, most but not all of the formulas are not calculating on
their own. I believe I have fixed this in the short term by using the
following sledgehammer when I am done with each worksheet.

Cells.Select
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

This really slows things down. Is there a more elegant way to do this
either with macros, computer settings, Excel settings, or something else?
Eventually I will work to reduce the number of equations, but can't do this
in the near term. Thanks in advance.

What does this "sledgehammer" do? I don't understand what you're doing.

"ZipCurs" wrote:

I am working in Excel 2007, although I don't think the problem is specific to
this. I have a workbook with about a 100 worksheets and 10's of thousands of
formulas. Basically, most but not all of the formulas are not calculating on
their own. I believe I have fixed this in the short term by using the
following sledgehammer when I am done with each worksheet.

Cells.Select
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

This really slows things down. Is there a more elegant way to do this
either with macros, computer settings, Excel settings, or something else?
Eventually I will work to reduce the number of equations, but can't do this
in the near term. Thanks in advance.

Hello Mike,

I got the method from the Excel General Methods Discussion page.
Apparently, by doing the equivelent of rewriting the equation, it will
actually calculate. It is kind of stupid, but it works. Otherwise, about
1/3 of the equations don't calculate.

I hope that there is a better way.

"Mike H." wrote:

What does this "sledgehammer" do? I don't understand what you're doing.

"ZipCurs" wrote:

I am working in Excel 2007, although I don't think the problem is specific to
this. I have a workbook with about a 100 worksheets and 10's of thousands of
formulas. Basically, most but not all of the formulas are not calculating on
their own. I believe I have fixed this in the short term by using the
following sledgehammer when I am done with each worksheet.

Cells.Select
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

This really slows things down. Is there a more elegant way to do this
either with macros, computer settings, Excel settings, or something else?
Eventually I will work to reduce the number of equations, but can't do this
in the near term. Thanks in advance.

Is TOOLSOPTIONSCALCULATIONS Set to AUTOMATIC ?


"ZipCurs" wrote in message
...
I am working in Excel 2007, although I don't think the problem is specific
to
this. I have a workbook with about a 100 worksheets and 10's of thousands
of
formulas. Basically, most but not all of the formulas are not calculating
on
their own. I believe I have fixed this in the short term by using the
following sledgehammer when I am done with each worksheet.

Cells.Select
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

This really slows things down. Is there a more elegant way to do this
either with macros, computer settings, Excel settings, or something else?
Eventually I will work to reduce the number of equations, but can't do
this
in the near term. Thanks in advance.