Thread: How can I update all workbooks in one go
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rsenn
 
Posts: n/a
Default How can I update all workbooks in one go

Shrek,

Try this and you'll see the answer.

Take a new workbook.

Select Sheet1.

Hold down the Shift key, and select Sheet3.

Sheets 1, 2 and 3 should now be highlighted as selected.

Select cell A1.

Type something into it. Hello World will do just fine.

Examine cell A1 in all three Sheets. They should all say Hello
World.

If necessary now ungroup the sheets. Right click on one of the
sheets. Select Ungroup Sheets.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=488357

Reply With QuoteReply With Quote