Cannot save Excel for Mac 2016 files to VM

Discussion in 'Windows Guest OS Discussion' started by ShaneO2, May 31, 2020.

  1. MatthewB32

    MatthewB32 Bit Poster

    On testing further, I was able to isolate the MACTF file issue, which appears to be generated by Excel and/or macOS for xlsx files, possibly related to the AutoRecover/AutoSave processes. Even when disabling all of those, and saving as xls instead of xlsx, I still get a similar error -- but it ends up being far simpler -- Excel cannot access /Volumes/ -- plain and simple.

    My current hypothesis is that Excel has a (likely long-antiquated) issue with saving to volumes that have brackets in their name -- and Parallels creates its shared volume on the Mac side with the legacy Windows drive letter in brackets -- "[C] Windows 11" in my case. You can see one aspect of this issue if you try to save an Excel file with brackets in the name -- Excel says no, although Word is fine with it.

    I can't seem to find anyway to change the naming convention Parallels uses when it mounts Windows drive images on the Mac side as a shared volume. There is a setting in the Parallels Control Center, under Options and then Sharing, to "Assign a drive letter to shared folders" which is checked by default. I unchecked it -- but based on where it appears (under Share Mac), it is for when you're mapping shared folders from the Mac side to Windows, not your actual local hard drive image or vice versa. I couldn't find any parallel (no pun intended) setting for omitting the drive letter for local drive(s) from the Windows side to Mac.
    Lorenzo11 likes this.
  2. Lorenzo11

    Lorenzo11 Bit Poster


    I have this very same problem and it's driving me nuts. Only with Excel. It's incredible this hasn't been fixed yet
  3. PeterG30

    PeterG30 Bit Poster

    Save and name a new spreadsheet
    Click anywhere in the spreadsheet window to make it active, then choose File > Save (from the File menu at the top of your screen).
    Enter a name in the Save As field, then enter one or more tags (optional).
    Click the Where pop-up menu and choose a location. ...
    Click Save.

    Hope This Helps,
  4. Lorenzo11

    Lorenzo11 Bit Poster

    Thanks for your answer. "save as" works as intended, but it's not exactly "practical" to save a new version of the file every time you want to change something.
  5. JohnP67

    JohnP67 Bit Poster

    Over 2 years and Parallels has not seemed to look into this. Since Bir Sur Parallels has a broken Bluetooth now as well. Granted it was initiated by Mac with updates in Big Sur but it got so hard to get Parallels to fix it they closed my case ! I've 3 parallels subscriptions, thinking of testing something else and moving away from them after many years. It's unfortunate.
    Lorenzo11 likes this.

Share This Page