Solved

Prevent window movement when linking from one Excel workbook to another

Posted on 2014-12-06
3
128 Views
Last Modified: 2014-12-24
Hello,

How do you prevent window movement when using hyperlinks between different Excel (2013) workbooks?

For example, suppose you have two workbooks (A.xlsm & B.xlsm) open and you position then side-by-side on your screen with A to the left and B to the right. And suppose you create a hyperlink in workbook A to a given cell in workbook B.

When the hyperlink is clicked in A it does jump to the destination cell in B as expected but at the same time, the window containing workbook B changes its screen position to perfectly overlie workbook A, thus obscuring the contents of workbook A.

A little experimenting revealed that the same screen position change occurs when the target is a bookmark in a Word doc (ie the window containing the Word doc moves to obscure the Excel window) but does not occur when the destination is a website. In other words, the browser window in which the destination website opens, remains where it is on the screen.

How can you create a link from one Excel workbook to another and have the window containing the latter maintain its original position?

Thanks
0
Comment
Question by:WeThotUWasAToad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 30

Expert Comment

by:gowflow
ID: 40489000
What do you mean by
 create a hyperlink in workbook A to a given cell in workbook B.

Can you post an example ?
gowflow
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40489297
I almost answered this a couple of days ago, but did some extra research to confirm.  The window behavior you're seeing when clicking a hyperlink to another Excel workbook is by design.  It is not possible to have the hyperlink retain the target file's "restored" position/size inside the Excel workspace.  The fact that IE (or any browser) behaves differently is just because it's a different type of application, namely NOT MS Office-related.

While you can link to a specific cell in another workbook (using the HYPERLINK function), there's no parameter available to control the output.  In order to do that, you'd need to use automation (VBA).

Regards,
-Glenn
0
 

Author Closing Comment

by:WeThotUWasAToad
ID: 40517337
Thanks Glenn
0

Featured Post

To Patch or not to Patch? That is the question!

Don't get caught out like thousands of others around the world in the recent Ransomware Fiasco!
Discuss..
- Why it's not a good idea to wait before Patching
- Sensible approaches to Patching discussed
- Add your feedback, comments and suggestions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question