Formulas in excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kate - 25 Nov 2007 23:41 GMT

Hi, I have a workbook that was created in excel 2003. Now we are using
excel 2007.
The formulas don't work work anymore.

Also, simple charts that were created in excel 2003, if you change the
cell values, the chart doesn't update.

Does anyone have an easy fix?

Thansk
Kate

Reply to this Message

ilia - 26 Nov 2007 01:36 GMT

Easy, no. Specifically what kinds of formulas are you migrating? For
charts, check your source data to make sure it's pointing to the
correct location.

> Hi, I have a workbook that was created in excel 2003. Now we are using
> excel 2007.
[quoted text clipped - 7 lines]
> Thansk
> Kate

Reply to this Message

Bernard Liengme - 26 Nov 2007 02:08 GMT

Could it be that Calculation is set to manual? Open Formulas tab and look at
calculations option (right of screen)
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi, I have a workbook that was created in excel 2003. Now we are using
> excel 2007.
[quoted text clipped - 7 lines]
> Thansk
> Kate

Reply to this Message