ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My Excel Chart No Longer Auto Updates (https://www.excelbanter.com/excel-discussion-misc-queries/111877-my-excel-chart-no-longer-auto-updates.html)

[email protected]

My Excel Chart No Longer Auto Updates
 
I have run into a problem where my excel charts no longer autoupdate.
I am not sure if it is because of macros I have written, but I doubt
it. When I update a cell from, say, 20 to 30, the chart does not
automatically update. The only way to see changes in the chart is to
click on source options and then have it pick up the source data line
again. Even though the source data line is already selected.

I have even checked Tools - Options - Calculation and ensured that it
is on automatic.

Any idea what could be going on here?


Martin

My Excel Chart No Longer Auto Updates
 
I'm having the same problem...can you send me the answer when you get it?

Thanks,


" wrote:

I have run into a problem where my excel charts no longer autoupdate.
I am not sure if it is because of macros I have written, but I doubt
it. When I update a cell from, say, 20 to 30, the chart does not
automatically update. The only way to see changes in the chart is to
click on source options and then have it pick up the source data line
again. Even though the source data line is already selected.

I have even checked Tools - Options - Calculation and ensured that it
is on automatic.

Any idea what could be going on here?




All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com