Free video converter for mac softonic. Total Video Converter for Mac. Total Video Converter for Mac is an all-in-one video toolbox for Mac OS X, which supports video conversion, DVD bunring, video editing and much more.

Click any linked cell to see or modify the link's source in the formula bar. The formula for links begins with an equals sign, and separates the spreadsheet's name and cell with an exclamation point. For example, the formula '=Sheet1!D2' links to cell D2 on Sheet1.

Hi, 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. I'm using an Excel workbook that has links to multiple external Excel workbooks. These files are saved on a USB removable storage drive. On my desktop PC, that USB is drive letter L. On my laptop PC, that USB is drive letter M. 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. Until recently, I've been running Windows 7 Pro and Office 2010 on both PCs.

However, I've recently acquired a new laptop that is running Windows 10 and Office 365 ProPlus. That's when this problem with absolute link references in Excel seems to have begun. 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. As a result, my link references always worked, no matter whether I was working on my desktop or my laptop, and life was wonderful. 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 the links have been forced to absolute references on the 'M:' drive. Needless to say, all of the links are now broken, and it takes quite a bit of effort to fix them. 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: ).

Also, I've confirmed that this drive letter/absolute reference issue occurs even when moving between two PCs that are both running 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.

OK, the easy solution would be to assign the same drive letter to the USB drive on both PCs. However, for reasons stated earlier, I'd prefer to not have to do that. Besides, I understand from Microsoft's knowledge base that Excel stores 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. That would seem to explain why Excel 2010 was working as it was, and apparently as it and Excel 2016 should be. Why is Excel 2016 not doing so?