Sheet linking to Another File, HLP!

F

FultonHogan

Hi, i am posting this question on behalf of a workmate. Im no Exce
expert, infact i know very little but sadly im IT support and my hel
is needed.

Here is the situation...

There is a spreadsheet with many different 'sheets?' along the bottom
Now all of these are maintained by the user exept for one.

He would like this one sheet to reveal an entire file that is locate
elsewhere on the network.
I have experimented with linking single cells at a time but this metho
is SO full of errors, especially when the format is changed etc.

Surely there is a simple way to link an entire sheet to another file b
entering a file path somewhere. This way he can have up-to-date inf
without having to copy paste. Sorry in advance if this is incredibl
simple, but i have mucked around for too long on this.

Cheers
 
R

RagDyer

I'm not sure if this is what you're looking for, but have you tried
"Hyperlinks"?

Try:
<Insert> <Hyperlink>,
And navigate (browse) to the particular file in question.
After you select it and click <OK>, a link will be created in the cell that
was in focus.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi, i am posting this question on behalf of a workmate. Im no Excel
expert, infact i know very little but sadly im IT support and my help
is needed.

Here is the situation...

There is a spreadsheet with many different 'sheets?' along the bottom.
Now all of these are maintained by the user exept for one.

He would like this one sheet to reveal an entire file that is located
elsewhere on the network.
I have experimented with linking single cells at a time but this method
is SO full of errors, especially when the format is changed etc.

Surely there is a simple way to link an entire sheet to another file by
entering a file path somewhere. This way he can have up-to-date info
without having to copy paste. Sorry in advance if this is incredibly
simple, but i have mucked around for too long on this.

Cheers.
 
Top