Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening then later Closing an Excel file in VBA | Excel Discussion (Misc queries) | |||
Slow Opening & Odd Closing | New Users to Excel | |||
Closing a workbook upon opening another | New Users to Excel | |||
How do I undo changes after saving and closing a document | Setting up and Configuration of Excel | |||
Event on opening/closing groupings in VBA | Excel Discussion (Misc queries) |