Cannot save Excel for Mac 2016 files to VM

hi
I have Excel 2016 installed on my Mac and Parallels 15 running Windows 10, but I have a Windows program which collects data for me every 2 hours. I need to write a macro which will open the file this program creates from the Windows side and copy the data to a standard Excel spreadsheet. For this to happen, I need to identify the exact location of the files on the VM; so it is not just C:\Prices\2020...which is the local folder on the VM. There is more to the exact location. I also need Excel to be able to open and save to the VM folders, which it cannot currently, yet I have all the correct permissions in PD.

So what I needed to do to identify the exact location of the folder is to create a new Excel blank file and save it to the folder on the VM. That was where problem 1 surfaced. The following message popped up when trying to save



So I saved the file on my Mac and copied it across to the VM. That works, so am wondering why Excel cannot save to that location. I then created a macro to tell me the exact location the file is in, but when I try to save the macro in the macro enabled file, the same message pops up.

How is it possible for Excel for Mac to have proper access to the VM folders, for both saving and opening?

Thanks in advance

 

Hello, could you please re-upload the screnshot? Unfortunately, we cannot open it

 

Hello Maria
Here is the screen shot
Thank you

 

So I am able to see the folder, in fact, I can even save the Excel file to the VM as a .csv or .pdf, but it simply is not possible to save a standard Excel spreadsheet file created in Excel installed on my Mac to the VM. Even if I copy a file across to the VM and open it from there, if I write a macro and try to save it in the file, I get the same message

Is it specifically an Excel issue or in PD? I am able to create a Word document and save it in the VM folders. The tech who did a remote session even disabled Avast to see if it was creating the issue, but it persisted. If I try to create a file and save it as a standard Excel format, .xls, .xlxs, .xlsm etc, it gives me that message. if I try to save as a Comma Separated Values file, .csv, no problems; even a .pdf is also fin.
Any thougts at all?

 

@ShaneO2 Please open System Preferences > Security & Privacy > Privacy and open Accessibility. Make sure that box next to Parallels Desktop is checked. Do the same for Full Disk Access. And also make sure that Sharing between Mac and Windows 10.

 

Hi Kayva
Thanks for your reply
Yes, PD is checked in Accessibility, but where is Full Disk Access


It is not an option I see anywhere there. I have the settings set to share Windows not share Mac

cheers

 

@ShaneO2 Please let us know your Mac OS version to check further.

 

High Sierra 10.13.6 (17G12034)

 

I've done the steps above and I still can't export files from parallels to excel on my mac. What am I missing?

 

Hello, did you repair or reinstall MS Office applications and check the issue?

 

Yes, I've done that now and did updates on system. Still can't connect to excel.

 

And did you check this article?

 

Hi Maria, did you found the solution to your problem? I am facing the same.

 

Hi, what is your Parallels Desktop version?

 

Mine is Parallels desktop pro edition

 

I have the same problem. I can save and make changes from Word on the mac to a folder on my windows VM, but I get this same error when trying from Excel. Have implemented the fixes mentioned here regarding full disk access and accessibility.

 

I too am facing the same issue, which is strange and only with Excel. Word or others are fine. Opening with Excel 365 in the Windows 10 environment and saving it works with no issues. Its only when opening the file from Finder using Excel (Mac), which does not allow it to be saved to the Windows 10 filesystem.

 

Guys, please let us know if the issue still actual and provide us with your Parallels Desktop and macOS versions

 

Parallels: 16.0.1 (48919)
macOS: 10.15.6

 

I'm having this problem too. I open an excel file stored on Windows 10 VM with Excel for Mac and it will not save back to the Windows 10 file. I have to save it on the Mac side.
Parallels: 16.0.1
MacOS: 10.13.6
Win10Pro: v.1909 18363.1016
Mac for Excel: 16.40