I'm using Excel 2007. I have a workbook that was created in Excel 2003 and
has formulas in it and the formals won't work anymore? Example of fomula
=sum(a1:a10). What do I have to due in Excel 2007 to get these formulas to
work? I could rewrite them but I have dozens on a sheet and don't want to
start all over again. I have click on the enable macros when it pops up.
Ihave tried changing it to a excel macro-enabled document and the formulas
still won't work.
Help!!!!
--
Carolan

Hi,
I don't see any problem with your formula below it should work, for the
macros save the spreasheet with extension Xlsm

if this helps please click yes, thanks

"CarolAn" wrote:

I'm using Excel 2007. I have a workbook that was created in Excel 2003 and
has formulas in it and the formals won't work anymore? Example of fomula
=sum(a1:a10). What do I have to due in Excel 2007 to get these formulas to
work? I could rewrite them but I have dozens on a sheet and don't want to
start all over again. I have click on the enable macros when it pops up.
Ihave tried changing it to a excel macro-enabled document and the formulas
still won't work.
Help!!!!
--
Carolan

These aren't macros.

Do you have calculation set to automatic or manual?

Office button|Excel Options|Formulas category (near the top)
is where you'd toggle this setting.

If this doesn't help, what does "doesn't work" mean?

CarolAn wrote:

I'm using Excel 2007. I have a workbook that was created in Excel 2003 and
has formulas in it and the formals won't work anymore? Example of fomula
=sum(a1:a10). What do I have to due in Excel 2007 to get these formulas to
work? I could rewrite them but I have dozens on a sheet and don't want to
start all over again. I have click on the enable macros when it pops up.
Ihave tried changing it to a excel macro-enabled document and the formulas
still won't work.
Help!!!!
--
Carolan

--

Dave Peterson