Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Fenian has attended:
Excel Introduction course
Excel Intermediate course

Excel

How do you link various excel documents from various pc's?

E.g. Excel doc A ( on PC 1) feeds info to Excel doc B ( on pc 2 )

Edited on Wed 20 Aug 2008, 08:28

RE: Excel

Hi Fenian,
Thank you for your post, for starters it is not as straightforward as first it would seem, the pc's would have to be on the same network, the files would need to be shared with the feeder's folder set to sharing as well. Once that is correctly set up then the procedure to link the files is quite straight forward. In PC1 open doc A and in the cell you wish to link to PC2 type an = (equals sign) navigate to the other PC2 and find the cell you wish to link to, select it and press Enter. You can now copy the link (formula) to other cells using Fill. I hope that helps regards Pete

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.