Cannot save Excel for Mac 2016 files to VM

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.
 
MatthewB32 said:
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.
Click to expand...

UP

I have this very same problem and it's driving me nuts. Only with Excel. It's incredible this hasn't been fixed yet
 
PeterG30 said:
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,
Peter
Click to expand...

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.
 
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.
 
I'm running into the same issue, Parallels is sharing full disk access, and save as works fine so long as you're saving somewhere within the local mac structure. This issue is only impacting excel for mac as far as I can tell. I can edit save in the hidden C drive using word and several other formats and programs as well.
 
I cannot believe three years in and this is still an issue. Bumping the thread because it's still not fixed. Yikes! Can save Word no problem, but Excel same issue as described.
 
Apparently I read somewhere that this issue is something in excel itself of which restricts Parallels from fixing it, hard to believe but guess it may be a possibility.
 
You must log in or register to reply here.
Back
Top