View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Refreshing a Worksheet

If both workbooks are open in the same excel session, then the updates are
automatic.

(well, if calculation is set to automatic. Do you have calculation set to
manual?)

Phil Hageman wrote:

Excel 2000

Working with to different workbooks: workbookA has
worksheetA, which has links to WorkbookB/WorksheetB. If I
make a change to WorksheetB, I would like to refresh
WorksheetA - to see the changes, without having to close
either Workbook. Is this possible?

Thanks,
Phil


--

Dave Peterson