Formulas in excel 2007

K

Kate

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
 
I

ilia

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.
 
B

Bernard Liengme

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic charts with named range Windows 8.1 3
Copying range of formulas to anotehr workbook 4
Excel2007 Replace formulas with {=#Value!} when saving file 2
Excel 2007 compatibility checker message 2
Calculation set to automatic switches 3
Automatic expanding formula bar in Excel 2007? 1
Excel 2007 sheet UDF return #Name in Excel 2003 4
Invalid References 1

Top