I have several spreadsheets which I used to track my finances. One of these is a Daily Tracker and for each month I have a separate Expenses spreadsheet.
I maintain a link in the Daily Tracker to a cell in the Expenses spreadsheet (which I change each month, manually).
I mainly maintain the spreadsheets on Windows and when I try to open the Daily Tracker on my Mac the links don't work.
The folder structure and relative locations of the Expenses spreadsheet is the same on both platforms but obviously the Mac does not have driver letters.
Is there any way to specify the link so that is works across the two platforms?
I maintain a link in the Daily Tracker to a cell in the Expenses spreadsheet (which I change each month, manually).
I mainly maintain the spreadsheets on Windows and when I try to open the Daily Tracker on my Mac the links don't work.
The folder structure and relative locations of the Expenses spreadsheet is the same on both platforms but obviously the Mac does not have driver letters.
Is there any way to specify the link so that is works across the two platforms?