Share via

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

Windows for business Windows Client for IT Pros Devices and deployment Set up, install, or upgrade
Microsoft 365 and Office Development Other
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanay Prasad 2,250 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.