ENABLE MACROS

  • Thread starter Thread starter CarolAn
  • Start date Start date
C

CarolAn

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!!!!
 
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
 
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?
 
Back
Top