A shared drive is useful only if both computers can open the files it carries. Before taking a workbook to a Windows-only meeting room, test the same physical drive on both machines.

Inspect the volume on each machine

On the Mac, open Disk Utility, select the external volume named TRANSFER, and read its format. On Windows, open This PC, right-click the matching volume, and open Properties to check its file system. ExFAT is one supported choice for this setup. If the drive needs to be reformatted, copy its contents elsewhere and verify that backup first because formatting erases the selected volume.

The TRANSFER volume is selected in Disk Utility and its format reads ExFAT.

Illustrated format check. Inspect the volume you plan to use.

Make a round trip before relying on it

Copy transfer-test.txt from Windows to the drive, eject it, and open that file on the Mac. If you need write access in both directions, save a separate mac-reply.txt on the drive, eject it from the Mac, and open that reply on Windows. Then copy and open the actual workbook on the receiving machine.

Windows writes transfer-test.txt and the Mac returns mac-reply.txt.

Illustrated round trip. Verify the files on the receiving computer each time.

Apple’s Disk Utility format reference