Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 213
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening then later Closing an Excel file in VBA Richard Excel Discussion (Misc queries) 1 April 22nd 08 02:07 PM
Slow Opening & Odd Closing ohsix New Users to Excel 1 May 20th 07 05:28 PM
Closing a workbook upon opening another Dave New Users to Excel 3 January 3rd 07 10:57 PM
How do I undo changes after saving and closing a document astrid Setting up and Configuration of Excel 2 April 7th 06 10:30 PM
Event on opening/closing groupings in VBA Dirk Flakowski Excel Discussion (Misc queries) 3 November 29th 05 04:52 PM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"