Excel file wont open because of ''missing objects that aren't on the device''

Cesar Franklin Basilio Vásquez 0 Reputation points
2023-07-09T05:27:09.3666667+00:00

I tried to open an Excel file that had macros, the problem is that when I opened it I got a message that said "A file is not executed correctly because it is missing objects that are not on the device" please help me to solve this

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,317 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,509 questions
Windows 10 Compatibility
Windows 10 Compatibility
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Compatibility: The extent to which hardware or software adheres to an accepted standard.
456 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,105 Reputation points
    2023-07-10T06:17:46.1233333+00:00

    Hi,

    So this error message indicates that the Excel file you are trying to open contains references to external objects or files that are missing. It may be due to Missing external files or missing add-ins or libraries.

    There are a few things you can try-

    1. Make sure that the macros are turned on in Excel's settings. Select "Options," then "Trust Centre," then "Trust Centre Settings" from the "File" tab. Go to "Macro Settings" in the Trust Centre and select the option to enable macros. Additionally, see if any security alerts are shown, and if so, follow the instructions to enable content.
    2. Check the file's content to find any references to outside files or data sources. Ensure that those files can be accessed and are in the proper location.
    3. Make sure the add-ins or libraries are installed on your system if the file depends on them.

    Best Regards.

    0 comments