Im not sure if this is at all possible but Im looking for a way to dynamically link a xlsm to a xlsx. It needs to be able to have both files open (the xlsm by one and the xlsx by a different user) and once information is entered into the xlsm file it updates the xlsx file….

Thank you for your help/suggestions