networked workbooks

Andrew XJ · Feb 23rd, 2002, 03:45 AM

There are two workbooks in two networked computers.
Workbook b.xls contains sheets("b1"), Sheets("b2")
Workbook c.xls contains sheets("c1"), Sheets("c2")

In another computer i want to create a new workbook a.xls. In a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").

b.xls and c.xls updates frequently. How can i create a.xls and make a.xls automatically changes with the changes of b.xls and c.xls.

Mudface · Feb 23rd, 2002, 04:40 AM

Create your new workbook ('a'). Copy the data in 'b', plus as many blank rows and columns as you think will be filled up eventually. Then just Paste Special- Paste Links onto the sheet in 'a' where you want the data to appear. Do the same for all the other sheets. You can copy entire sheets in this way, but it usually leads to a very large workbook. Hope that helps.

Jack in the UK · Feb 23rd, 2002, 09:13 AM

Hi

Just a point can you not share the book / ss with password access to a token ring on the network

IE YOUR Shared workbooks network inside main network

Thus no updating, set show changes at once and every one can update togethen, as set save to autosave every 2 mins,,,,,

Rdgs
==========
Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2002, 03:45 AM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	There are two workbooks in two networked computers. Workbook b.xls contains sheets("b1"), Sheets("b2") Workbook c.xls contains sheets("c1"), Sheets("c2") In another computer i want to create a new workbook a.xls. In a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1"). b.xls and c.xls updates frequently. How can i create a.xls and make a.xls automatically changes with the changes of b.xls and c.xls.

Feb 23rd, 2002, 04:40 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Create your new workbook ('a'). Copy the data in 'b', plus as many blank rows and columns as you think will be filled up eventually. Then just Paste Special- Paste Links onto the sheet in 'a' where you want the data to appear. Do the same for all the other sheets. You can copy entire sheets in this way, but it usually leads to a very large workbook. Hope that helps.

Feb 23rd, 2002, 09:13 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Just a point can you not share the book / ss with password access to a token ring on the network IE YOUR Shared workbooks network inside main network Thus no updating, set show changes at once and every one can update togethen, as set save to autosave every 2 mins,,,,, Rdgs ========== Jack