Refresh or update needed

Aspose.Cells Product Family
1

I’m writing data into a cell (M19), which another cell refinances (BM19). BM19 has a simple =M19 formula.

The problem is a chart looks to BM19. After I insert data into M19 and pass the excel file to the browser the chart simply does not display the data. If I click on M19, as click as though I’m entering a formula or new value, then hit enter, the chart refreshes.

Is there anyway to trigger this refresh before I send the file to the browser?

Thanks,
Rick

2

This problem is caused by setting in your MS Excel. Please change your setting by this:

In MS Excel,

Tools->Options->Calculation

Please change calculation option from “Manual” to “Automatic”.