Updating Document Without Closing and Re-Opening
 

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

Updating Document Without Closing and Re-Opening
 

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

Updating Document Without Closing and Re-Opening
 

Sounds like automatic calculation has been turned off. You can either press
F9 to recalculate on a manual basis, or you can go to
Tools-Options-Calculation, and turn on automatic calculation. Note that if
the workbook is very large (contains lots of formulas) it may be better to
leave it on manual calculation to help reduce calculation time.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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