Forum Discussion
Hathaway7
Apr 12, 2023Copper Contributor
Linking two files
Hello,
As you can see from the 1st attachment (car fleet), I would like to double-click on a cell or whichever is the best way to automatically open up a separate file (car fleet 2) which provides a drill down detail of 'car fleet'. Is that possible?
Thanks
Michael
- NikolinoDEGold Contributor
As far as I could gather from your text...
Yes, it is possible to link two Excel files so that when you double-click on a cell in one file, it opens up another file that provides more detailed information.
Here’s how you can do it:
- Open the first file (car fleet) and select the cell that you want to link.
- Right-click on the cell and select “Hyperlink” from the context menu.
- In the “Insert Hyperlink” dialog box, select “Existing File or Web Page” on the left side of the dialog box.
- Navigate to and select the second file (car fleet 2) that you want to link to.
- Click “OK” to create the hyperlink.
Now, when you double-click on the cell in the first file (car fleet), it will automatically open up the second file (car fleet 2) that provides more detailed information.
If it's not what was wanted, please include the following info to help others answer your question:
Welcome to your Excel discussion space!
I hope this helps!
- Hathaway7Copper ContributorI appreciate your help. It works perfectly. Thanks again.
- NikolinoDEGold ContributorI'm glad I could help you a little with your project.
I wish you continued success with Excel.