Tools Options Calculation check automatic
--
Gary''s Student - gsnu200836


"Randy" wrote:

I have cells on a spreadsheet that have certain formulas that update other
cells on the same spreadsheet but.......the cells won't update unless you
close the workbook and then re-open it.

Is there a way i can update the spreadsheet, maybe with a macro or
something, without having to close and re-open?

Thanks
Randy