Blakieto
03-16-2005, 08:35 PM
I have a workbook with 7 sheets and considerable VBA macro logic driving the values in various cells, plus some button activated macros that take values from cells and generate a large table that is used as input to a graph...
Today, after adding a macro that simply calculates a reference number (unused anywhere else) the entire workbook's linkage of sheet to sheet formulas stopped auto-updating.
The options menu's automatic calculation option is still selected.
I can do a [ctrl][alt][shift]F9 to recalculate a single sheet, but the sheets have nested logic that requires me to recalculate A, then B, then C, then A again and so on... Plus the sheet with the chart never recalculates anymore. I tried quitting Excel and reloading, and that worked once. After that, a reboot worked once. Now... nothing.:banghead:
I've tried removing any references to the macro I just added. That does not seem to help.
I guess as a starting point, what would cause a chart to stop updating? The cell values it references have clearly changed...!!!
I wish could post the workbook, but it is full of proprietary company info, so I can not...:(
Any ideas?
Today, after adding a macro that simply calculates a reference number (unused anywhere else) the entire workbook's linkage of sheet to sheet formulas stopped auto-updating.
The options menu's automatic calculation option is still selected.
I can do a [ctrl][alt][shift]F9 to recalculate a single sheet, but the sheets have nested logic that requires me to recalculate A, then B, then C, then A again and so on... Plus the sheet with the chart never recalculates anymore. I tried quitting Excel and reloading, and that worked once. After that, a reboot worked once. Now... nothing.:banghead:
I've tried removing any references to the macro I just added. That does not seem to help.
I guess as a starting point, what would cause a chart to stop updating? The cell values it references have clearly changed...!!!
I wish could post the workbook, but it is full of proprietary company info, so I can not...:(
Any ideas?