Excel should automatically adjust the formulas for the local user when the workbook is opened. I'm not familiar with Mac versions of Excel, but I'd be very surprised if they work differently in this respect. I assume that the formulae exist in the workbook when the user opens it and they're not, for example, being dynamically added by VBA?

Are both users using the same version of Excel? Can you attach an example workbook?