Fix UTM “File size exceeds the limit allowed” issue

 

Environment:

1.     MacBook Pro 2021, Apple M1 Pro Silicon

2.     UTM version: 3.2.4(58)

3.     Virtual Machine: Windows 11 21H2 ARM

 

Symptoms

Tried to copy a 50M file from the shared folder to the windows virtual machine, got a popup error window:

 

An unexpected error is keeping you from copying the file. If you continue to receive this error, you can use the error code to search for help with this problem.

 

Error 0x800700DF: The file size exceeds the limit allowed and cannot be saved.

 

 

 

Solution

Run “regedit”, open Registry Editor.

 

Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters

 

Right click on the FileSizeLimitInBytes and click Modify

 

Click on Decimal

 

In the Value data box, type 4294967295, and then click OK. (extend the file size limit to 4G).

 

Uninstall Application on Mac

1.  Application folder
2. ~/Library/<Application Name>
3. ~/Library/Caches/com.<applicaion _name.*>
4. ~/Library/Saved Application State/<com.application_name.*>
   

How to update the data source of an excel sheet

 

After a CSV file was imported to the excel file, the excel sheet will have connection with the CSV file. If the CSV file was deleted or moved to other folder, you might get the data source error when you try to refresh the data connection:

To quickly fix this error, Open the excel sheet, click menu “Data” > “Queries & Connections” to open the “Queries & Connections” panel, which normally is on the right side of the excel sheet. 

On the “Queries” tab, double click the query that has issue.

This opens the “Power Query Editor” window. Click Menu “Home” > “Advanced Editor” 

On the “Advanced Editor” pop-up window, modify the Source, enter the new Absolute Path of the CSV file. Click Done. This should update the data source.

Another thing that worth to mention is the encoding setting.  I have to change the encoding to 65001, which is “UTF-8”, (Encoding=65001), in order to display some French characters in the CSV file.