P
pikapika13
At work, I have created a spreadsheet that has links to workbooks in a
user drive..called the "U: drive."
When I transfer this excel project to others via email, I make sure
that the other workbooks also have the same name in their U: drive as
well.
However, whenever I email it... I have to change many of the formulas
at their computers bc the references in my formulas change to a really
long string.
I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't
work for me bc I have "+" "=" elsewhere in my formulas.
Is there a better way to have my excel spreadsheet formulas remain
exactly the same even when I email it?
user drive..called the "U: drive."
When I transfer this excel project to others via email, I make sure
that the other workbooks also have the same name in their U: drive as
well.
However, whenever I email it... I have to change many of the formulas
at their computers bc the references in my formulas change to a really
long string.
I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't
work for me bc I have "+" "=" elsewhere in my formulas.
Is there a better way to have my excel spreadsheet formulas remain
exactly the same even when I email it?