Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I update all workbooks in one go
I have 4 workbooks which have 5 sheets in each. All the worksheets are the same layout apart from they are named mon-fri. Im trying to set it up so when I amend one box it will amend and update all the other sheets in the workbooks. When I was given the workbook to re design I noticed that this was avail on some boxes using a file named control.xls. Can anyone help me cos I aint got a clue what this control file is and its a pain keep amending every every worksheet in the books when I sure there must be a way to update all in one go. Many Thanks -- shrek |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
Can you link many workbooks to one template? And Update? | Excel Discussion (Misc queries) | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
Update multiple workbooks automatically | Excel Worksheet Functions | |||
Link & Update Two Workbooks | Excel Worksheet Functions |