problem copying Excel data from a remote Windows computer directly to an Excel sheet on my Mac.

PSCHER

I can get the remote Excel data copied to an Excel sheet on the remote computer and then from remote Excel sheet to my Excel sheet on my Mac but not direct from Excel to Excel.If I do not ensure that the remote dat column is wide enough the date data is not copied across but just