98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 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 )
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:No ZerosWant all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK. |