Solved

Prevent window movement when linking from one Excel workbook to another

Posted on 2014-12-06
3
129 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 31

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

627 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