When I update data for an embedded chart often the chart will not update unless I save and close the file then reopen it. Any ideas to get charts to update? F9 doesn't work.
Why is the chart embedded? If using regular XL, it should just be regularly placed, not embedded somewhere.
Otherwise, I'd check Formulas - Calculation Options, and make sure your in Automatic mode. Sometimes this gets turned to Manual, which makes everything get screwy.
Even stranger...moving to the oddball questions
Are PivotTables involved anywhere?
What type of functions are used in your formulas?
Any macros at all in your file?