Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bill Le May
 
Posts: n/a
Default How do I force a reload of the workbook?

I want to execute an occasional reload of a workbook, reverting to the last
saved version, discarding any current changes. I tried the Refresh command
from the Web toolbar but this doesn't always work - it becomes greyed
out/unavailable.

Short of writing a macro is there a refresh/reload command that I can assign
to a toolbar?

Thanks,

Bill Le May


  #2   Report Post  
Jim Cone
 
Posts: n/a
Default

Bill,

You will have to close (without saving) the workbook and reopen it.

Regards,
Jim Cone
San Francisco, USA


"Bill Le May" wrote in message ...
I want to execute an occasional reload of a workbook, reverting to the last
saved version, discarding any current changes. I tried the Refresh command
from the Web toolbar but this doesn't always work - it becomes greyed
out/unavailable.

Short of writing a macro is there a refresh/reload command that I can assign
to a toolbar?

Thanks,

Bill Le May


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
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? Bill O'Neal Excel Worksheet Functions 8 August 14th 09 11:36 PM
How to hyperlink from a workbook to sheets in another workbook? MJOHNSON Excel Worksheet Functions 0 February 17th 05 08:31 PM
Unprotect Workbook Kent Excel Discussion (Misc queries) 1 February 4th 05 01:07 AM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 03:05 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM


All times are GMT +1. The time now is 02:00 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"