Share via

Is it possible to use the RECHERCHEV function between two EXCEL files on ONE DRIVE ?

Anonymous
2025-06-16T15:27:55+00:00

I am presently using many RECHERCHEV between different EXCEL files on my computer.

I will put these files on ONE DRIVE to share them with other users.

How will the RECHERCHEV functions run ?

I have tried, and apparently it doesn't work. But perhaps I didn't set the links properly.

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-06-16T21:43:04+00:00

    Hello Dominique,

    Welcome to Microsoft Community.

    . I understand you're experiencing issues with your RECHERCHEV (VLOOKUP) formulas after moving your Excel files to OneDrive. My appologies for the troubles caused

    To better assist you, could you please clarify the following

    Are all the linked files saved in the same OneDrive folder or subfolders?

    Are you and the other users accessing the files via the OneDrive sync client or through the browser (Excel Online)?
    Are the files shared with edit permissions?

    Here are some helpful troubleshooting Steps

    1. Check File Paths:

    When files are moved to OneDrive, Excel may not automatically update the file paths in your formulas.

    Open the file with the RECHERCHEV formulas and check if the links still point to the local file paths (e.g., C:\Users...) instead of the OneDrive cloud path
    2. Update Links:

    Go to Data > Edit Links in Excel (if available) and update the source to the new OneDrive location.

    Alternatively, reinsert the RECHERCHEV formula and manually browse to the new file location on OneDrive.

    1. Check Sharing and Permissions:

    Ensure the files are shared with the correct users and that they have permission to access and edit them.

    If using Excel Online, note that some advanced features like external links may not work as expected.
    4. Test in Excel Desktop App:

    If you're using Excel Online, try opening the files in the desktop version of Excel, which has better support for linked workbooks.

    Your feedback will be appreciated

    Best Regards,
    Sunday | Microsoft Community Support Specialist

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more