lasasbud.blogg.se - Relative hyperlinks in excel 2016

Relative hyperlinks in excel 2016 update#
Relative hyperlinks in excel 2016 windows 10#
Relative hyperlinks in excel 2016 pro#
Relative hyperlinks in excel 2016 Pc#

Relative hyperlinks in excel 2016 update#

If the links are relative (Excel 2010), I get what I want (analyze new data in 20161008) in a simple and transparent way (no link update is needed). copy 20161007 path containing analysis and data files to 20161008 path), update the data file in the new path (20161008) and analyze it with the analysis file. New data file is delivered, I just copy-paste the path containing both files in a new path (i.e. And I usually keep different versions of analysis + data files in different paths. The analysis file has links to the data one. My main reason to use this is that I have a "data" excel file and an "analysis" excel file. Excel 2016 keeps absolute path (full path, including drive letter) between 2 files in the same path. Excel 2010 kept relative links between 2 files in the same path. Same problem for me Excel 2010 vs 2016 behaviour. In the meantime, thank you wrdar for your time and thoughts! It seems to me that, if Excel 2016 by default stores only the relative portions of the paths to linked files, then a simple change of USB's drive letter between two different computers shouldn't break the links.Ĭan anyone suggest what I may be missing? Otherwise, I'm starting to sense this may be a bug that Microsoft needs to fix.

Relative hyperlinks in excel 2016 Pc#

The only thing that changes from PC to Laptop is that the OS has assigned a different drive letter to the USB drive. In fact, the linked file and the sources files continue to reside on the same USB drive, and in the same directory I won't claim to be an expert, but everything I read in that article leads me to believe that Excel 2016 should behave in regard to my issue exactly asĪlso, in this situation, the linked file isn't being moved away from source files that are in a central (or networked) location. I had previously seen the kb article you referenced, and I've studied it further at your suggestion. Thanks in advance to anyone who can shed some light on this! Sorry for the long post, but I did want to clearly communicate the problem.

Short of assigning identical drive letters to the USB drive, is there anything I can do to fix this problem?.

Is there a new "switch" in Excel 2016 that controls this behavior?.

Have other Excel 2016 users run into this same problem?.

Why is Excel 2016 not doing so?Ĭould someone advise me on the following? That would seem to explain why Excel 2010 was workingĪs it was, and apparently as it and Excel 2016 should be. Relative link references by default - meaning that it only saves the information necessary to specify the location of the linked workbooks relative to the position of the "main" workbook. Besides, I understand from Microsoft's knowledge base that Excel stores However, for reasons stated earlier, I'd prefer to not have to do that. OK, the easy solution would be to assign the same drive letter to the USB drive on both PCs.

Relative hyperlinks in excel 2016 windows 10#

So, this appears to be an Excel 2016/Windows 10 issue, and not an issue of migrating between Excel 2016/Excel 2010 or Windows 10 Pro/Windows 7 Pro. Moving between two PCs that are both running Excel 2016/Windows 10. Also, I've confirmed that this drive letter/absolute reference issue occurs even when Please note that the links are still relative references when I move from my desktop to the laptop (i.e., the link paths dynamically change from L:\ to M:\). Needless to say, all of the links are now broken, and it takes quite a bit of effort to fix them. The links have been forced to absolute references on the "M:" drive. However, with the introduction of Excel 2016 (as part of Office 365 ProPlus), I'm finding that when I move the USB drive from laptop to desktop (which is still running Excel 2010/Windows 7 Pro) and attempt to work on the Excel workbook, all of Matter whether I was working on my desktop or my laptop, and life was wonderful. As a result, my link references always worked, no Previously, in Excel 2010, when I moved to and from desktop/laptop, the link references in my Excel workbook changed dynamically according to USB's assigned drive letter on that particular PC. That's when this problem with absolute link references in Excel seems However, I've recently acquired a new laptop that is running Windows 10 and Office 365 ProPlus.

Relative hyperlinks in excel 2016 pro#

Until recently, I've been running Windows 7 Pro and Office 2010 on both PCs. Not to go into too much detail, but I find it helpful in my billing activities (using Outlook Journal) to be able to discern on what PC I was working on the file at a given time. On my laptop PC, that USB is drive letter On my desktop PC, that USB is drive letter L. These files are saved on a USB removable storage drive. I'm using an Excel workbook that has links to multiple external Excel workbooks. I've searched this forum to no avail on this issue, but if I've missed another thread with a solution, please point me in that direction.