I have developed a tool with several worksheets in the workbook and each
has many functions referencing the value of other cells in the same
sheet. Auto calculation is on, however some of the pages don't
automatically update when I change the referenced cells.
This seems to be on a sheet by sheet basis. I am not getting any "out
of memory" messages. If I activate the cell, and press enter it will
update, but it won't calc sheet, and it doesn't update those sheets
when i hit F9.
Help, I need this tool working.