how to fix error 52 in excel

Sandeep Singh 25 Reputation points

I am getting an error 52 while preparing a .json file by using an excel formula. how do I fix it?

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
941 questions
{count} votes

Accepted answer
  1. Tanay Prasad 1,845 Reputation points


    This error can occur if Excel encounters an issue related to the file name or file path.

    Here are some methods that you can try-

    1. File locking can prevent Excel from creating or overwriting the file. Check if the file is locked by another process or application.
    2. Try specifying a different folder location (e.g., your desktop) to see if the issue is specific to the current directory.
    3. Ensure that you have the necessary permissions to create files in the specified directory.

    Also, refer to this thread-

    Best Regards.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 17,231 Reputation points Microsoft Vendor


    Based on the error 52, this problem is related to the file name, please refer to this support to get more information:

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments