We have an Excel spreadsheet that uses data from another workbook.
We use Dropbox to share the files.
When I open the spreadsheet on another Mac or PC the links need relinking.
Is there a way to make the links reference just the immediate folder?
Here's the problem explained further.
Workbook contains a link to: ~my-mac/dropbox/work/source.xlsx
It doesn't work when opened on: ~ãnother-mac/dropbox/work/source.xlsx
I want Excel 2011 for Mac just to look for ~/dropbox/work/source.xlsx
I've read several help pages on Absoulte links and relative links and UNC links. It seems it is possible to link workbooks using the short link, however, I am unable to make it work.
Is it a Mac thing? Is it a me thing?
Any potshots from hotshots most welcome!