Cannot save Excel for Mac 2016 files to VM

Discussion in 'Accessing your PC' started by ShaneO2, May 31, 2020.

  1. ShaneO2

    ShaneO2 Bit Poster

    Messages:
    5
    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

    [​IMG]

    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
     
  2. Maria@Parallels

    Maria@Parallels Parallels Team

    Messages:
    5,769
    Hello, could you please re-upload the screnshot? Unfortunately, we cannot open it
     
  3. ShaneO2

    ShaneO2 Bit Poster

    Messages:
    5
    Hello Maria
    Here is the screen shot
    Thank you Screen Shot 2563-06-01 at 08.17.52.png
     
  4. ShaneO2

    ShaneO2 Bit Poster

    Messages:
    5
    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?
     
  5. kavyaM@Parallels

    kavyaM@Parallels Staff Member

    Messages:
    78
    @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.
     
  6. ShaneO2

    ShaneO2 Bit Poster

    Messages:
    5
    Hi Kayva
    Thanks for your reply
    Yes, PD is checked in Accessibility, but where is Full Disk Access
    Screen Shot 2563-06-03 at 17.51.48.png

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

    cheers
     
  7. kavyaM@Parallels

    kavyaM@Parallels Staff Member

    Messages:
    78
    @ShaneO2 Please let us know your Mac OS version to check further.
     
  8. ShaneO2

    ShaneO2 Bit Poster

    Messages:
    5
    High Sierra 10.13.6 (17G12034)
     
  9. KathyY

    KathyY Bit Poster

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

    Attached Files:

  10. Maria@Parallels

    Maria@Parallels Parallels Team

    Messages:
    5,769
    Hello, did you repair or reinstall MS Office applications and check the issue?
     
  11. KathyY

    KathyY Bit Poster

    Messages:
    2
    Yes, I've done that now and did updates on system. Still can't connect to excel.
     
  12. Maria@Parallels

    Maria@Parallels Parallels Team

    Messages:
    5,769
    And did you check this article?
     

Share This Page